Civil Engineering Projects
Macro 19: Unhide All Worksheets in a Workbook
If you've ever had to unhide multiple sheets in Excel, you know what a pain it is. You need to ...
Macro 18: Hide All but the Active Worksheet
You may not want to delete all but the active sheet as we did in the last macro. Instead, a more ...
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 ...
