Working with Worksheets
In This Chapter
Adding and naming worksheets
Protecting and unprotecting worksheets
Creating a table of contents
Highlighting active rows and columns
Hiding and unhiding worksheets
Moving and sorting Worksheets
Copying worksheets to new Workbooks
Excel analysts can save time and gain efficiencies by using macros to automate tasks related to worksheets. Two common example tasks are unhiding all sheets in a workbook and printing all sheets at the same time. In this chapter, I cover some of the more useful macros related to worksheets.
Adding and Naming a New Worksheet
The chapter starts with one of the simplest worksheet-related automations you can apply with a macro: adding and naming a new worksheet.
How the macro works
When you read through the ...