WorkbookEvents_Event WorkbookEvents_Event WorkbookEvents_Event Interface


Events interface for ExcelWorkbook object events.

public interface class WorkbookEvents_Event
public interface WorkbookEvents_Event
Public Interface WorkbookEvents_Event


Activate Activate Activate

Occurs when a workbook is activated.

AddinInstall AddinInstall AddinInstall

Occurs when the workbook is installed as an add-in.

AddinUninstall AddinUninstall AddinUninstall

Occurs when the workbook is uninstalled as an add-in.

AfterSave AfterSave AfterSave

Occurs after the workbook is saved.

AfterXmlExport AfterXmlExport AfterXmlExport

Occurs after Excel saves or exports data from the specified workbook to an XML data file.

AfterXmlImport AfterXmlImport AfterXmlImport

Occurs after an existing XML data connection is refreshed or after new XML data is imported into the specified Excel workbook.

BeforeClose BeforeClose BeforeClose

Occurs before the workbook closes. If the workbook has been changed, this event occurs before the user is asked to save changes.

BeforePrint BeforePrint BeforePrint

Occurs before the workbook (or anything in it) is printed.

BeforeSave BeforeSave BeforeSave

Occurs before the workbook is saved.

BeforeXmlExport BeforeXmlExport BeforeXmlExport

Occurs before Excel saves or exports data from the specified workbook to an XML data file.

BeforeXmlImport BeforeXmlImport BeforeXmlImport

Occurs before an existing XML data connection is refreshed or before new XML data is imported into an Excel workbook.

Deactivate Deactivate Deactivate

Occurs when the workbook is deactivated.

ModelChange ModelChange ModelChange

Occurs after the Excel data model is changed.

NewChart NewChart NewChart

Occurs when a new chart is created in the workbook.

NewSheet NewSheet NewSheet

Occurs when a new sheet is created in the workbook.

Open Open Open

Occurs when the workbook is opened.

PivotTableCloseConnection PivotTableCloseConnection PivotTableCloseConnection

Occurs after a PivotTable report closes the connection to its data source.

PivotTableOpenConnection PivotTableOpenConnection PivotTableOpenConnection

Occurs after a PivotTable report opens the connection to its data source.

RowsetComplete RowsetComplete RowsetComplete

The event is raised when the user either drills through the recordset or invokes the rowset action on an OLAP PivotTable.

SheetActivate SheetActivate SheetActivate

Occurs when any sheet is activated.

SheetBeforeDelete SheetBeforeDelete SheetBeforeDelete

Occurs before the worksheet is deleted.

SheetBeforeDoubleClick SheetBeforeDoubleClick SheetBeforeDoubleClick

Occurs when any worksheet is double-clicked, before the default double-click action.

SheetBeforeRightClick SheetBeforeRightClick SheetBeforeRightClick

Occurs when any worksheet is right-clicked, before the default right-click action.

SheetCalculate SheetCalculate SheetCalculate

Occurs after any worksheet is recalculated or after any changed data is plotted on a chart.

SheetChange SheetChange SheetChange

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

SheetDeactivate SheetDeactivate SheetDeactivate

Occurs when any sheet is deactivated.

SheetFollowHyperlink SheetFollowHyperlink SheetFollowHyperlink

Occurs when you click any hyperlink in Microsoft Excel.

SheetLensGalleryRenderComplete SheetLensGalleryRenderComplete SheetLensGalleryRenderComplete

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

SheetPivotTableAfterValueChange SheetPivotTableAfterValueChange SheetPivotTableAfterValueChange

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

SheetPivotTableBeforeAllocateChanges SheetPivotTableBeforeAllocateChanges SheetPivotTableBeforeAllocateChanges

Occurs before changes are applied to a PivotTable.

SheetPivotTableBeforeCommitChanges SheetPivotTableBeforeCommitChanges SheetPivotTableBeforeCommitChanges

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

SheetPivotTableBeforeDiscardChanges SheetPivotTableBeforeDiscardChanges SheetPivotTableBeforeDiscardChanges

Occurs before changes to a PivotTable are discarded.

SheetPivotTableChangeSync SheetPivotTableChangeSync SheetPivotTableChangeSync

Occurs after changes to a PivotTable.

SheetPivotTableUpdate SheetPivotTableUpdate SheetPivotTableUpdate

Occurs after the sheet of the PivotTable report has been updated.

SheetSelectionChange SheetSelectionChange SheetSelectionChange

Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).

SheetTableUpdate SheetTableUpdate SheetTableUpdate

Occurs after the sheet table has been updated.

Sync Sync 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 WindowActivate WindowActivate

Occurs when any workbook window is activated.

WindowDeactivate WindowDeactivate WindowDeactivate

Occurs when any workbook window is deactivated.

WindowResize WindowResize WindowResize

Occurs when any workbook window is resized.

Applies to