Application Object Events

Application events occur when a workbook is created or opened, when any sheet in any open workbook changes, or when any PivotTable is created or opened. To write event procedures for the Application object, you must create a new object using the WithEvents keyword in a class module. For more information, see Using Events with the Application Object.

NewWorkbook SheetActivate SheetBeforeDoubleClick SheetBeforeRightClick SheetCalculate SheetChange SheetDeactivate SheetFollowHyperlink SheetSelectionChange SheetPivotTableUpdate WindowActivate WindowDeactivate

WindowResize WorkbookActivate WorkbookAddinInstall WorkbookAddinUninstall WorkbookBeforeClose WorkbookBeforePrint WorkbookBeforeSave WorkbookDeactivate WorkbookNewSheet WorkbookOpen WorkbookPivotTableCloseConnection WorkbookPivotTableOpenConnection

See Also

• Chart Object Events
• Control and Dialog Box Events
• Using Events with Embedded Charts
• Using Events with Excel Objects
• Using Events with the Application Object
• Worksheet Object Events