Part III: Automating Worksheet Tasks with Macros
This Part addresses macros that work at the worksheet level. In this Part, you'll find macros for adding, deleting, and renaming worksheets, and much more.
In This Part
Macro 16 Add and Name a New Worksheet
Macro 17 Delete All but the Active Worksheet
Macro 18 Hide All but the Active Worksheet
Macro 19 Unhide All Worksheets in a Workbook
Macro 20 Moving Worksheets Around
Macro 21 Sort Worksheets by Name
Macro 22 Group Worksheets by Color
Macro 23 Copy a Worksheet to a New Workbook
Macro 24 Create a New Workbook for Each Worksheet
Macro 25 Print Specified Worksheets
Macro 26 Protect All Worksheets
Macro 27 Unprotect All Worksheets
Macro 28 Create a Table of Contents for Your Worksheets
Macro 29 Zooming In and Out of a Worksheet with Double-Click
Get 101 Ready-To-Use Excel Macros now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.