Workbook events
Office 2013 and later
The Workbook type exposes the following members.
| Name | Description | |
|---|---|---|
|
Activate | Occurs when a workbook is activated. (Inherited from WorkbookEvents_Event.) |
|
AddinInstall | Occurs when the workbook is installed as an add-in. (Inherited from WorkbookEvents_Event.) |
|
AddinUninstall | Occurs when the workbook is uninstalled as an add-in. (Inherited from WorkbookEvents_Event.) |
|
AfterSave | Occurs after the workbook is saved. (Inherited from WorkbookEvents_Event.) |
|
AfterXmlExport | Occurs after Excel saves or exports data from the specified workbook to an XML data file. (Inherited from WorkbookEvents_Event.) |
|
AfterXmlImport | Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Excel workbook. (Inherited from WorkbookEvents_Event.) |
|
BeforeClose | Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes. (Inherited from WorkbookEvents_Event.) |
|
BeforePrint | Occurs before the workbook (or anything in it) is printed. (Inherited from WorkbookEvents_Event.) |
|
BeforeSave | Occurs before the workbook is saved. (Inherited from WorkbookEvents_Event.) |
|
BeforeXmlExport | Occurs before Excel saves or exports data from the specified workbook to an XML data file. (Inherited from WorkbookEvents_Event.) |
|
BeforeXmlImport | Occurs before an existing XML data connection is refreshed or before new XML data is imported into an Excel workbook. (Inherited from WorkbookEvents_Event.) |
|
Deactivate | Occurs when the workbook is deactivated. (Inherited from WorkbookEvents_Event.) |
|
ModelChange | Occurs after the Excel data model is changed. (Inherited from WorkbookEvents_Event.) |
|
NewChart | Occurs when a new chart is created in the workbook. (Inherited from WorkbookEvents_Event.) |
|
NewSheet | Occurs when a new sheet is created in the workbook. (Inherited from WorkbookEvents_Event.) |
|
Open | Occurs when the workbook is opened. (Inherited from WorkbookEvents_Event.) |
|
PivotTableCloseConnection | Occurs after a PivotTable report closes the connection to its data source. (Inherited from WorkbookEvents_Event.) |
|
PivotTableOpenConnection | Occurs after a PivotTable report opens the connection to its data source. (Inherited from WorkbookEvents_Event.) |
|
RowsetComplete | The event is raised when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable. (Inherited from WorkbookEvents_Event.) |
|
SheetActivate | Occurs when any sheet is activated. (Inherited from WorkbookEvents_Event.) |
|
SheetBeforeDelete | Occurs before the worksheet is deleted. (Inherited from WorkbookEvents_Event.) |
|
SheetBeforeDoubleClick | Occurs when any worksheet is double-clicked, before the default double-click action. (Inherited from WorkbookEvents_Event.) |
|
SheetBeforeRightClick | Occurs when any worksheet is right-clicked, before the default right-click action. (Inherited from WorkbookEvents_Event.) |
|
SheetCalculate | Occurs after any worksheet is recalculated or after any changed data is plotted on a chart. (Inherited from WorkbookEvents_Event.) |
|
SheetChange | Occurs when cells in any worksheet are changed by the user or by an external link. (Inherited from WorkbookEvents_Event.) |
|
SheetDeactivate | Occurs when any sheet is deactivated. (Inherited from WorkbookEvents_Event.) |
|
SheetFollowHyperlink | Occurs when you click any hyperlink in Microsoft Excel. (Inherited from WorkbookEvents_Event.) |
|
SheetLensGalleryRenderComplete | Occurs when a callout gallery’s icons (dynamic and static) have completed rendering for a worksheet. (Inherited from WorkbookEvents_Event.) |
|
SheetPivotTableAfterValueChange | Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas). (Inherited from WorkbookEvents_Event.) |
|
SheetPivotTableBeforeAllocateChanges | Occurs before changes are applied to a PivotTable. (Inherited from WorkbookEvents_Event.) |
|
SheetPivotTableBeforeCommitChanges | Occurs before changes are committed against the OLAP data source for a PivotTable. (Inherited from WorkbookEvents_Event.) |
|
SheetPivotTableBeforeDiscardChanges | Occurs before changes to a PivotTable are discarded. (Inherited from WorkbookEvents_Event.) |
|
SheetPivotTableChangeSync | Occurs after changes to a PivotTable. (Inherited from WorkbookEvents_Event.) |
|
SheetPivotTableUpdate | Occurs after the sheet of the PivotTable report has been updated. (Inherited from WorkbookEvents_Event.) |
|
SheetSelectionChange | Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet). (Inherited from WorkbookEvents_Event.) |
|
SheetTableUpdate | Occurs after the sheet table has been updated. (Inherited from WorkbookEvents_Event.) |
|
Sync | Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server. (Inherited from WorkbookEvents_Event.) |
|
WindowActivate | Occurs when any workbook window is activated. (Inherited from WorkbookEvents_Event.) |
|
WindowDeactivate | Occurs when any workbook window is deactivated. (Inherited from WorkbookEvents_Event.) |
|
WindowResize | Occurs when any workbook window is resized. (Inherited from WorkbookEvents_Event.) |
Show: