Worksheet Events



Worksheet Activate Event

This event occurs when a workbook, worksheet, chart sheet, or embedded chart is activated.


Worksheet BeforeDoubleClick Event

This event occurs when a worksheet is double-clicked, before the default double-click action.


Worksheet BeforeRightClick Event

This event occurs when a worksheet is right-clicked, before the default right-click action.


Worksheet Calculate Event

This event occurs after the worksheet is recalculated, for the Worksheet object.


Worksheet Change Event

This event occurs when cells on the worksheet are changed by the user or by an external link.


Worksheet Deactivate Event

This event occurs when the chart, worksheet, or workbook is deactivated.


Worksheet FollowHyperlink Event

This event occurs when you click any hyperlink on a worksheet. For application- and workbook-level events, see the SheetFollowHyperlink event and SheetFollowHyperlink event.


Worksheet PivotTableAfterValueChange Event

This event occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).


Worksheet PivotTableBeforeAllocateChanges Event

This event occurs before changes are applied to a PivotTable.


Worksheet PivotTableBeforeCommitChanges Event

This event occurs before changes are committed against the OLAP data source for a PivotTable.


Worksheet PivotTableBeforeDiscardChanges Event

This event occurs before changes to a PivotTable are discarded.


Worksheet PivotTableChangeSync Event

This event occurs after changes to a PivotTable.


Worksheet PivotTableUpdate Event

This event occurs after a PivotTable report is updated on a worksheet.


Worksheet SelectionChange Event

This event occurs when the selection changes on a worksheet.