Worksheet events
Office 2013 and later
The Worksheet type exposes the following members.
| Name | Description | |
|---|---|---|
|
Activate | Occurs when a worksheet is activated. (Inherited from DocEvents_Event.) |
|
|
BeforeDelete | The BeforeDelete event occurs before any sheet is deleted. (Inherited from DocEvents_Event.) |
|
|
BeforeDoubleClick | Occurs when a worksheet is double-clicked, before the default double-click action. (Inherited from DocEvents_Event.) |
|
|
BeforeRightClick | Occurs when a worksheet is right-clicked, before the default right-click action. (Inherited from DocEvents_Event.) |
|
|
Calculate | Occurs after the worksheet is recalculated. (Inherited from DocEvents_Event.) |
|
|
Change | Occurs when cells on the worksheet are changed by the user or by an external link. (Inherited from DocEvents_Event.) |
|
|
Deactivate | Occurs when the worksheet is deactivated. (Inherited from DocEvents_Event.) |
|
|
FollowHyperlink | Occurs when you click any hyperlink on a worksheet. For application- and workbook-level events, see the SheetFollowHyperlink event. (Inherited from DocEvents_Event.) |
|
|
LensGalleryRenderComplete | Occurs when a callout gallery’s icons (dynamic and static) have completed rendering. (Inherited from DocEvents_Event.) |
|
|
PivotTableAfterValueChange | Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas). (Inherited from DocEvents_Event.) |
|
|
PivotTableBeforeAllocateChanges | Occurs before changes are applied to a PivotTable. (Inherited from DocEvents_Event.) |
|
|
PivotTableBeforeCommitChanges | Occurs before changes are committed against the OLAP data source for a PivotTable. (Inherited from DocEvents_Event.) |
|
|
PivotTableBeforeDiscardChanges | Occurs before changes to a PivotTable are discarded. (Inherited from DocEvents_Event.) |
|
|
PivotTableChangeSync | Occurs after changes to a PivotTable. (Inherited from DocEvents_Event.) |
|
|
PivotTableUpdate | Occurs after a PivotTable report is updated on a worksheet. (Inherited from DocEvents_Event.) |
|
|
SelectionChange | Occurs when the selection changes on a worksheet. (Inherited from DocEvents_Event.) |
|
|
TableUpdate | Occurs after a Query table connected to the Data Model is updated on a worksheet. (Inherited from DocEvents_Event.) |
Show: