Excel Macros For Dummies, 3rd Edition

Chapter 5

Working with Worksheets

IN THIS CHAPTER

Adding, naming, copying, and deleting worksheets

Hiding and unhiding, moving, sorting, and grouping worksheets

Protecting and unprotecting all worksheets

Printing and creating a table of contents for your worksheets

Zooming in and out of a worksheet

Excel analysts often need to automate tasks related to worksheets. Whether it is unhiding all sheets in a workbook, or printing all sheets at the same time, many tasks can be automated to save time and gain efficiencies. This chapter covers some of the more useful macros related to worksheets.

Installing Macros

You can install the macros in this chapter in three places depending on what kind of macro it is and how available you want the macro to be. Event macros are put into the module of the object the event is tied to. Non-event macros go into a standard module and can be in the workbook in which they are meant to run or in a workbook called the Personal Macro Workbook if you want to ...