Edit

WorkbookEvents_Event Interface

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

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
ComVisibleAttribute

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.

Applies to