Condividi tramite


WorkbookEvents_Event Members

Events interface for Microsoft Excel Workbook object events.

The following tables list the members exposed by the WorkbookEvents_Event type.

Public Methods

  Name Description
add_Activate  
add_AddinInstall  
add_AddinUninstall  
add_AfterXmlExport  
add_AfterXmlImport  
add_BeforeClose  
add_BeforePrint  
add_BeforeSave  
add_BeforeXmlExport  
add_BeforeXmlImport  
add_Deactivate  
add_NewSheet  
add_Open  
add_PivotTableCloseConnection  
add_PivotTableOpenConnection  
add_SheetActivate  
add_SheetBeforeDoubleClick  
add_SheetBeforeRightClick  
add_SheetCalculate  
add_SheetChange  
add_SheetDeactivate  
add_SheetFollowHyperlink  
add_SheetPivotTableUpdate  
add_SheetSelectionChange  
add_Sync  
add_WindowActivate  
add_WindowDeactivate  
add_WindowResize  
remove_Activate  
remove_AddinInstall  
remove_AddinUninstall  
remove_AfterXmlExport  
remove_AfterXmlImport  
remove_BeforeClose  
remove_BeforePrint  
remove_BeforeSave  
remove_BeforeXmlExport  
remove_BeforeXmlImport  
remove_Deactivate  
remove_NewSheet  
remove_Open  
remove_PivotTableCloseConnection  
remove_PivotTableOpenConnection  
remove_SheetActivate  
remove_SheetBeforeDoubleClick  
remove_SheetBeforeRightClick  
remove_SheetCalculate  
remove_SheetChange  
remove_SheetDeactivate  
remove_SheetFollowHyperlink  
remove_SheetPivotTableUpdate  
remove_SheetSelectionChange  
remove_Sync  
remove_WindowActivate  
remove_WindowDeactivate  
remove_WindowResize  

Top

Public Events

  Name Description
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.
AfterXmlExport Occurs after Microsoft 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 Microsoft 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 Microsoft 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 a Microsoft Excel workbook.
Deactivate Occurs when the workbook is deactivated.
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.
SheetActivate Occurs when any sheet is activated.
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.
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).
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.

Top

See Also

Reference

WorkbookEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace