Part II: Working with Workbooks
This Part covers macros related to workbooks: opening them, closing them, protecting them, and many other actions.
In This Part
Macro 1 Creating a New Workbook from Scratch
Macro 2 Saving a Workbook when a Particular Cell Is Changed
Macro 3 Saving a Workbook before Closing
Macro 4 Protect a Worksheet on Workbook Close
Macro 5 Unprotect a Worksheet on Workbook Open
Macro 6 Open a Workbook to a Specific Tab
Macro 7 Opening a Specific Workbook Defined by the User
Macro 8 Determine Whether a Workbook Is Already Open
Macro 9 Determine Whether a Workbook Exists in a Directory
Macro 10 Refresh All Data Connections in Workbook on Open
Macro 11 Close all Workbooks at Once
Macro 12 Open All Workbooks in a Directory
Macro 13 Print all Workbooks in a Directory
Macro 14 Preventing the Workbook from Closing until a Cell Is Populated
Macro 15 Create a Backup of a Current Workbook with Today's Date
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.