Application events
Office 2013 and later
The Application type exposes the following members.
| Name | Description | |
|---|---|---|
|
AfterCalculate | The AfterCalculate event occurs when all pending refresh activity (both synchronous and asynchronous) and all of the resultant calculation activities have been completed. (Inherited from AppEvents_Event.) |
|
NewWorkbook | Occurs when a new workbook is created. (Inherited from AppEvents_Event.) |
|
ProtectedViewWindowActivate | Occurs when a Protected View window is activated. (Inherited from AppEvents_Event.) |
|
ProtectedViewWindowBeforeClose | Occurs immediately before a Protected View window or a workbook in a Protected View window closes. (Inherited from AppEvents_Event.) |
|
ProtectedViewWindowBeforeEdit | Occurs immediately before editing is enabled on the workbook in the specified Protected View window. (Inherited from AppEvents_Event.) |
|
ProtectedViewWindowDeactivate | Occurs when a Protected View window is deactivated. (Inherited from AppEvents_Event.) |
|
ProtectedViewWindowOpen | Occurs when a workbook is opened in a Protected View window. (Inherited from AppEvents_Event.) |
|
ProtectedViewWindowResize | Occurs when any Protected View window is resized. (Inherited from AppEvents_Event.) |
|
SheetActivate | Occurs when any sheet is activated. (Inherited from AppEvents_Event.) |
|
SheetBeforeDelete | (Inherited from AppEvents_Event.) |
|
SheetBeforeDoubleClick | Occurs when any worksheet is double-clicked, before the default double-click action. (Inherited from AppEvents_Event.) |
|
SheetBeforeRightClick | Occurs when any worksheet is right-clicked, before the default right-click action. (Inherited from AppEvents_Event.) |
|
SheetCalculate | Occurs after any worksheet is recalculated or after any changed data is plotted on a chart. (Inherited from AppEvents_Event.) |
|
SheetChange | Occurs when cells in any worksheet are changed by the user or by an external link. (Inherited from AppEvents_Event.) |
|
SheetDeactivate | Occurs when any sheet is deactivated. (Inherited from AppEvents_Event.) |
|
SheetFollowHyperlink | Occurs when you click any hyperlink in Microsoft Excel. (Inherited from AppEvents_Event.) |
|
SheetLensGalleryRenderComplete | Occurs after a callout gallery’s icons (dynamic and static) have finished rendering. (Inherited from AppEvents_Event.) |
|
SheetPivotTableAfterValueChange | Occurs after a cell or range of cells inside a PivotTable are edited or recalculated (for cells that contain formulas). (Inherited from AppEvents_Event.) |
|
SheetPivotTableBeforeAllocateChanges | Occurs before changes are applied to a PivotTable. (Inherited from AppEvents_Event.) |
|
SheetPivotTableBeforeCommitChanges | Occurs before changes are committed against the OLAP data source for a PivotTable. (Inherited from AppEvents_Event.) |
|
SheetPivotTableBeforeDiscardChanges | Occurs before changes to a PivotTable are discarded. (Inherited from AppEvents_Event.) |
|
SheetPivotTableUpdate | Occurs after the sheet of the PivotTable report has been updated. (Inherited from AppEvents_Event.) |
|
SheetSelectionChange | Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet). (Inherited from AppEvents_Event.) |
|
SheetTableUpdate | Occurs when a table on a worksheet is updated. (Inherited from AppEvents_Event.) |
|
WindowActivate | Occurs when any workbook window is activated. (Inherited from AppEvents_Event.) |
|
WindowDeactivate | Occurs when any workbook window is deactivated. (Inherited from AppEvents_Event.) |
|
WindowResize | Occurs when any workbook window is resized. (Inherited from AppEvents_Event.) |
|
WorkbookActivate | Occurs when any workbook is activated. (Inherited from AppEvents_Event.) |
|
WorkbookAddinInstall | Occurs when a workbook is installed as an add-in. (Inherited from AppEvents_Event.) |
|
WorkbookAddinUninstall | Occurs when any add-in workbook is uninstalled. (Inherited from AppEvents_Event.) |
|
WorkbookAfterSave | Occurs after the workbook is saved. (Inherited from AppEvents_Event.) |
|
WorkbookAfterXmlExport | Occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file. (Inherited from AppEvents_Event.) |
|
WorkbookAfterXmlImport | Occurs after an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook. (Inherited from AppEvents_Event.) |
|
WorkbookBeforeClose | Occurs immediately before any open workbook closes. (Inherited from AppEvents_Event.) |
|
WorkbookBeforePrint | Occurs before any open workbook is printed. (Inherited from AppEvents_Event.) |
|
WorkbookBeforeSave | Occurs before any open workbook is saved. (Inherited from AppEvents_Event.) |
|
WorkbookBeforeXmlExport | Occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file. (Inherited from AppEvents_Event.) |
|
WorkbookBeforeXmlImport | Occurs before an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook. (Inherited from AppEvents_Event.) |
|
WorkbookDeactivate | Occurs when any open workbook is deactivated. (Inherited from AppEvents_Event.) |
|
WorkbookModelChange | Occurs when the data model is updated. (Inherited from AppEvents_Event.) |
|
WorkbookNewChart | Occurs when a new chart is created in any open workbook. (Inherited from AppEvents_Event.) |
|
WorkbookNewSheet | Occurs when a new sheet is created in any open workbook. (Inherited from AppEvents_Event.) |
|
WorkbookOpen | Occurs when a workbook is opened. (Inherited from AppEvents_Event.) |
|
WorkbookPivotTableCloseConnection | Occurs after a PivotTable report connection has been closed. (Inherited from AppEvents_Event.) |
|
WorkbookPivotTableOpenConnection | Occurs after a PivotTablereport connection has been opened. (Inherited from AppEvents_Event.) |
|
WorkbookRowsetComplete | The WorkbookRowsetCompleteevent occurs when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable. (Inherited from AppEvents_Event.) |
|
WorkbookSync | Occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server. (Inherited from AppEvents_Event.) |
Show: