1156
Chapter 43 Building Custom Applications with VBA
Controlling How VBA Applications Start
There are countless ways to run a macro. The most direct way, of course, is to work your
way through the pull-down menus into the Macros dialog box, where you can make a selec-
tion and then click Run. But there are far more efficient and productive ways to automate
work processes, especially when you’re creating a document, workbook, or presentation that
you want to pass along to other users.
You can create a macro that runs automatically every time a user opens a specific Word doc-
ument or Excel workbook, for example. Excel keeps track of 20 workbook-related ...