Share via


Worksheet Events (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

This object has the following events:

Events

Name

Description

Activate

Occurs when a workbook, worksheet, chart sheet, or embedded chart is activated.

BeforeDelete

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, for the Worksheet object.

Change

Occurs when cells on the worksheet are changed by the user or by an external link.

Deactivate

Occurs when the chart, worksheet, or workbook is deactivated.

FollowHyperlink

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

LensGalleryRenderComplete

Occurs when a callout gallery’s icons (dynamic & static) have completed rendering.

PivotTableAfterValueChange

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

PivotTableBeforeAllocateChanges

Occurs before changes are applied to a PivotTable.

PivotTableBeforeCommitChanges

Occurs before changes are committed against the OLAP data source for a PivotTable.

PivotTableBeforeDiscardChanges

Occurs before changes to a PivotTable are discarded.

PivotTableChangeSync

Occurs after changes to a PivotTable.

PivotTableUpdate

Occurs after a PivotTable report is updated on a worksheet.

SelectionChange

Occurs when the selection changes on a worksheet.

TableUpdate

Occurs after a Query table connected to the Data Model is updated on a worksheet.