AppEvents_Event Members

Events interface for Microsoft Excel Application object events.

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

Public Methods

  Name Description
add_NewWorkbook  
add_SheetActivate  
add_SheetBeforeDoubleClick  
add_SheetBeforeRightClick  
add_SheetCalculate  
add_SheetChange  
add_SheetDeactivate  
add_SheetFollowHyperlink  
add_SheetPivotTableUpdate  
add_SheetSelectionChange  
add_WindowActivate  
add_WindowDeactivate  
add_WindowResize  
add_WorkbookActivate  
add_WorkbookAddinInstall  
add_WorkbookAddinUninstall  
add_WorkbookAfterXmlExport  
add_WorkbookAfterXmlImport  
add_WorkbookBeforeClose  
add_WorkbookBeforePrint  
add_WorkbookBeforeSave  
add_WorkbookBeforeXmlExport  
add_WorkbookBeforeXmlImport  
add_WorkbookDeactivate  
add_WorkbookNewSheet  
add_WorkbookOpen  
add_WorkbookPivotTableCloseConnection  
add_WorkbookPivotTableOpenConnection  
add_WorkbookSync  
remove_NewWorkbook  
remove_SheetActivate  
remove_SheetBeforeDoubleClick  
remove_SheetBeforeRightClick  
remove_SheetCalculate  
remove_SheetChange  
remove_SheetDeactivate  
remove_SheetFollowHyperlink  
remove_SheetPivotTableUpdate  
remove_SheetSelectionChange  
remove_WindowActivate  
remove_WindowDeactivate  
remove_WindowResize  
remove_WorkbookActivate  
remove_WorkbookAddinInstall  
remove_WorkbookAddinUninstall  
remove_WorkbookAfterXmlExport  
remove_WorkbookAfterXmlImport  
remove_WorkbookBeforeClose  
remove_WorkbookBeforePrint  
remove_WorkbookBeforeSave  
remove_WorkbookBeforeXmlExport  
remove_WorkbookBeforeXmlImport  
remove_WorkbookDeactivate  
remove_WorkbookNewSheet  
remove_WorkbookOpen  
remove_WorkbookPivotTableCloseConnection  
remove_WorkbookPivotTableOpenConnection  
remove_WorkbookSync  

Top

Public Events

  Name Description
NewWorkbook Occurs when a new workbook is created.
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).
WindowActivate Occurs when any workbook window is activated.
WindowDeactivate Occurs when any workbook window is deactivated.
WindowResize Occurs when any workbook window is resized.
WorkbookActivate Occurs when any workbook is activated.
WorkbookAddinInstall Occurs when a workbook is installed as an add-in.
WorkbookAddinUninstall Occurs when any add-in workbook is uninstalled.
WorkbookAfterXmlExport Occurs after Microsoft Excel saves or exports data from any open workbook to an XML data file.
WorkbookAfterXmlImport Occurs after an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook.
WorkbookBeforeClose Occurs immediately before any open workbook closes.
WorkbookBeforePrint Occurs before any open workbook is printed.
WorkbookBeforeSave Occurs before any open workbook is saved.
WorkbookBeforeXmlExport Occurs before Microsoft Excel saves or exports data from any open workbook to an XML data file.
WorkbookBeforeXmlImport Occurs before an existing XML data connection is refreshed or new XML data is imported into any open Microsoft Excel workbook.
WorkbookDeactivate Occurs when any open workbook is deactivated.
WorkbookNewSheet Occurs when a new sheet is created in any open workbook.
WorkbookOpen Occurs when a workbook is opened.
WorkbookPivotTableCloseConnection Occurs after a PivotTable report connection has been closed.
WorkbookPivotTableOpenConnection Occurs after a PivotTable report connection has been opened.
WorkbookSync Occurs when the local copy of a workbook that is part of a Document Workspace is synchronized with the copy on the server.

Top

See Also

Reference

AppEvents_Event Interface
Microsoft.Office.Interop.Excel Namespace