Learn
Macro 8: Determine Whether a Workbook Is Already Open The previous macro automatically opened a workbook based on the user's selection. As we ...
Macro 7: Opening a Specific Workbook Defined by the User Want to give yourself or your users a quick way to search for and open a file? This ...
Macro 6: Open a Workbook to a Specific Tab In some situations, it's imperative that your workbook be started on a specific worksheet. With this ...
Macro 5: Unprotect a Worksheet on Workbook Open If you've distributed workbooks with protected sheets, you likely get the workbooks back with the ...
Macro 3: Saving a Workbook Before Closing This macro is an excellent way to protect users from inadvertently closing their file before saving. ...
Macro 2: Saving a Workbook When a Particular Cell Is Changed Sometimes, you may be working on data that is so sensitive that you'll want to ...
Macro 1: Creating a New Workbook from Scratch You may sometimes want or need to create a new workbook in an automated way. For instance, you ...
Taking a Brief Look at Variables Another concept you will see throughout the macros in this book is the concept of variables. We need to ...
Discovering the Excel Object Model In Excel, you deal with workbooks, worksheets, and ranges on a daily basis. You likely think of each of ...
Customizing the VBA Environment If you're serious about becoming an Excel programmer, you'll spend a lot of time with VBA modules on your ...
