Chapter 12
Automatic Procedures and Events
IN THIS CHAPTER
Knowing the event types that can trigger an execution
Finding out where to place your event-handler VBA code
Executing a macro when a workbook is opened or closed
Executing a macro when a workbook or worksheet is activated
You have a number of ways to execute a VBA Sub procedure. One way is to arrange for the Sub to be executed automatically. In this chapter, you explore the ins and outs of this potentially useful feature, learning how to set things up so that a macro is executed automatically when a particular event occurs.
Preparing for the Big Event
An event is basically something that happens in Excel. Following are a few examples of the types of events that Excel can recognize:
- A workbook is opened or closed.
- A window is activated or deactivated.
- A worksheet is activated or deactivated.
- Data in a cell is entered or changed.
- A workbook is saved.
- An object, such as a button, is clicked.
- A particular key or key combination is pressed.
- A particular time of day occurs.
- An error occurs.
Dozens of different types of events ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access