Microsoft® Office Excel 2003 Programming Inside Out

Chapter 12. Understanding and Using Events

Enabling and Disabling Events

Workbook Events

Worksheet Events

Application Events

Within Microsoft Excel, any actions that occur, such as opening a workbook, saving the file or recalculating a worksheet, are referred to as events. Some events are triggered by the application and some by the user, but no matter how the event is initiated, by assigning procedures to these events you can enhance how the user interacts with your Excel application.

When a trigger occurs, Excel will look for an event procedure named Object_EventName, in which Object is the object that generates and contains the event, and EventName is the name of the specific trigger. For example, when the user changes the selection, either by clicking ...