Chapter 17. Automating Procedures with Excel Events
Understanding Excel Events
An event occurs in Excel whenever the user performs any type of action. For example, an event occurs when the user closes a workbook. You can use events to trigger the execution of procedures by creating event procedures. Event procedures are exactly what the name describes: procedures that execute when a particular event occurs.
To trap or capture an event with an event procedure, you must place the procedure code in the correct type of module. For example, workbook-related events must be in the
ThisWorkbook object standard module.
There are several categories of events. Each event category has a set of events associated with it. For example, the
BeforeClose event is ...