WorkbookEvents_Event Interface
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Events interface for ExcelWorkbook object events.
public interface class WorkbookEvents_Event
[System.Runtime.InteropServices.ComVisible(false)]
public interface WorkbookEvents_Event
Public Interface WorkbookEvents_Event
- Derived
- Attributes
Events
Activate |
Occurs when a workbook 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 Excel saves or exports data from the specified workbook to an XML data file. |
AfterXmlImport |
Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified 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 Excel saves or exports data from the specified workbook to an XML data file. |
BeforeXmlImport |
Occurs before an existing XML data connection is refreshed or before new XML data is imported into an Excel workbook. |
Deactivate |
Occurs when the 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 |
Occurs before the worksheet is deleted. |
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. |
SheetLensGalleryRenderComplete |
Occurs when a callout gallery’s icons (dynamic and 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 |
Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server. |
WindowActivate |
Occurs when any workbook window is activated. |
WindowDeactivate |
Occurs when any workbook window is deactivated. |
WindowResize |
Occurs when any workbook window is resized. |