Worksheet Events

The worksheet-related events are shown in Table 11-1. These events are also referred to as document events.

Table 11-1. Worksheet Events (DocEvents)

Event name	Description
Activate	Occurs when a worksheet is activated.
BeforeDoubleClick	Occurs when a worksheet is double-clicked, before the default double-click action.
BeforeRightClick	Occurs when a worksheet is right-clicked, before the default right-click action.
Calculate	Occurs after the worksheet is recalculated.
Change	Occurs when cells on the worksheet are changed by the user or by an external link.
Deactivate	Occurs when the worksheet is deactivated.
PivotTableUpdate (Excel 10 only)	Occurs after a PivotTable report is updated on a worksheet.
SelectionChange	Occurs when the selection changes on a worksheet.