Workbook Events

 

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

NameDescription
System_CAPS_pubeventActivateEvent

Occurs when the workbook is activated.

System_CAPS_pubeventAddinInstall

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

System_CAPS_pubeventAddinUninstall

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

System_CAPS_pubeventAfterSave

Occurs after the workbook is saved.

System_CAPS_pubeventAfterXmlExport

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

System_CAPS_pubeventAfterXmlImport

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

System_CAPS_pubeventBeforeClose

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

System_CAPS_pubeventBeforePrint

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

System_CAPS_pubeventBeforeSave

Occurs before the workbook is saved.

System_CAPS_pubeventBeforeXmlExport

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

System_CAPS_pubeventBeforeXmlImport

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

System_CAPS_pubeventBindingContextChanged

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubeventDeactivate

Occurs when the workbook is deactivated.

System_CAPS_pubeventDisposed

(Inherited from IComponent.)

System_CAPS_pubeventNew

Occurs when a new workbook is created.

System_CAPS_pubeventNewChart

Occurs when a new chart is created in the workbook.

System_CAPS_pubeventNewSheet

Occurs when a new sheet is created in the workbook.

System_CAPS_pubeventOpen

Occurs when the workbook is opened.

System_CAPS_pubeventPivotTableCloseConnection

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

System_CAPS_pubeventPivotTableOpenConnection

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

System_CAPS_pubeventRowsetComplete

Occurs when the user navigates through the recordset or invokes the rowset action on an OLAP PivotTable.

System_CAPS_pubeventSheetActivate

Occurs when any sheet is activated.

System_CAPS_pubeventSheetBeforeDoubleClick

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

System_CAPS_pubeventSheetBeforeRightClick

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

System_CAPS_pubeventSheetCalculate

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

System_CAPS_pubeventSheetChange

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

System_CAPS_pubeventSheetDeactivate

Occurs when any sheet is deactivated.

System_CAPS_pubeventSheetFollowHyperlink

Occurs when you click any hyperlink in a workbook.

System_CAPS_pubeventSheetPivotTableAfterValueChange

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

System_CAPS_pubeventSheetPivotTableBeforeAllocateChanges

Occurs before changes are applied to a PivotTable.

System_CAPS_pubeventSheetPivotTableBeforeCommitChanges

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

System_CAPS_pubeventSheetPivotTableBeforeDiscardChanges

Occurs before changes to a PivotTable are discarded.

System_CAPS_pubeventSheetPivotTableChangeSync

Occurs after changes to a PivotTable.

System_CAPS_pubeventSheetPivotTableUpdate

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

System_CAPS_pubeventSheetSelectionChange

Occurs when the selection changes on any worksheet. Does not occur if the selection is on a chart sheet.

System_CAPS_pubeventShutdown

Occurs when the workbook host item shuts down.

System_CAPS_pubeventStartup

Occurs after the workbook is running and all the initialization code in the assembly has been run.

System_CAPS_pubeventSyncEvent

Occurs when the local copy of a worksheet that is part of a Document Workspace is synchronized with the copy on the server.

System_CAPS_pubeventWindowActivate

Occurs when any workbook window is activated.

System_CAPS_pubeventWindowDeactivate

Occurs when any workbook window is deactivated.

System_CAPS_pubeventWindowResize

Occurs when any workbook window is resized.

Return to top
Show: