Learn
Macro 17: Delete All but the Active Worksheet At times, you may want to delete all but the active worksheet. In these situations, you can use ...
Macro 16: Add and Name a New Worksheet We start off this chapter with one of the simplest worksheet-related automations you can apply with a ...
Macro 15: Create a Backup of a Current Workbook with Today's Date We all know that making backups of your work is important. Now you can have a ...
Macro 4: Protect a Worksheet on Workbook Close Sometimes you need to send your workbook out into the world with specific worksheets protected. If ...
Macro 14: Preventing the Workbook from Closing Until a Cell Is Populated There are times when you don't want a user closing out a workbook ...
Macro 13: Print All Workbooks in a Directory If you need to print from multiple workbooks in a directory, you can use this macro. How it works ...
Macro 12: Open All Workbooks in a Directory Here's a scenario: You've written a cool macro that applies some automated processing to each work- ...
Macro 11: Close All Workbooks at Once One of the more annoying things in Excel is closing many workbooks at once. For each workbook you have ...
Macro 10: Refresh All Data Connections in Workbook on Open Your workbook may have connections to external data sources such as web queries, ...
Macro 9: Determine Whether a Workbook Exists in a Directory You may have a process that manipulates a file somewhere on your PC. For example, you ...
