Workbook Events (Excel)

Article
05/23/2016

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.
AddinInstall	Occurs when the workbook is installed as an add-in
AddinUninstall	Occurs when the workbook is uninstalled as an add-in.
AfterSave	Occurs after the workbook is saved.
AfterXmlExport	Occurs after Microsoft Excel saves or exports XML data from the specified workbook.
AfterXmlImport	Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Microsoft Excel workbook.
BeforeClose	Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.
BeforePrint	Occurs before the workbook (or anything in it) is printed.
BeforeSave	Occurs before the workbook is saved.
BeforeXmlExport	Occurs before Microsoft Excel saves or exports XML data from the specified workbook.
BeforeXmlImport	Occurs before an existing XML data connection is refreshed or before new XML data is imported into a Microsoft Excel workbook.
Deactivate	Occurs when the chart, worksheet, or workbook is deactivated.
ModelChange	Occurs after the Excel data model is changed.
NewChart	Occurs when a new chart is created in the workbook.
NewSheet	Occurs when a new sheet is created in the workbook.
Open	Occurs when the workbook is opened.
PivotTableCloseConnection	Occurs after a PivotTable report closes the connection to its data source.
PivotTableOpenConnection	Occurs after a PivotTable report opens the connection to its data source.
RowsetComplete	The event is raised when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.
SheetActivate	Occurs when any sheet is activated.
SheetBeforeDelete
SheetBeforeDoubleClick	Occurs when any worksheet is double-clicked, before the default double-click action.
SheetBeforeRightClick	Occurs when any worksheet is right-clicked, before the default right-click action.
SheetCalculate	Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.
SheetChange	Occurs when cells in any worksheet are changed by the user or by an external link.
SheetDeactivate	Occurs when any sheet is deactivated.
SheetFollowHyperlink	Occurs when you click any hyperlink in Microsoft Excel. For worksheet-level events, see the Help topic for the FollowHyperlink event.
SheetLensGalleryRenderComplete	Occurs when a callout gallery’s icons (dynamic & static) have completed rendering for a worksheet.
SheetPivotTableAfterValueChange	Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas).
SheetPivotTableBeforeAllocateChanges	Occurs before changes are applied to a PivotTable.
SheetPivotTableBeforeCommitChanges	Occurs before changes are committed against the OLAP data source for a PivotTable.
SheetPivotTableBeforeDiscardChanges	Occurs before changes to a PivotTable are discarded.
SheetPivotTableChangeSync	Occurs after changes to a PivotTable.
SheetPivotTableUpdate	Occurs after the sheet of the PivotTable report has been updated.
SheetSelectionChange	Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).
SheetTableUpdate	Occurs after the sheet table has been updated.
Sync	This object or member has been deprecated, but it remains part of the object model for backward compatibility. You should not use it in new applications.
WindowActivate	Occurs when any workbook window is activated.
WindowDeactivate	Occurs when any workbook window is deactivated.
WindowResize	Occurs when any workbook window is resized.

Workbook Events (Excel)

Events

Additional resources