Chapter 9. Event Programming


Levels of Events

Earlier in the book, you saw mention of workbook events and have seen examples of worksheet events. Events are Excel’s way of letting you execute code based on certain actions that take place in a workbook.

These events can be found at the following levels:

  • Application level—Control based on application actions, such as Application_NewWorkbook

  • Workbook level—Control based on workbook actions, such as Workbook_Open

  • Worksheet level—Control based on worksheet actions, such as Worksheet_SelectionChange

  • Chart sheet ...

Get Business Solutions VBA and Macros for Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.