Search notes:

Excel Object Model: Workbook events

activate activate is called before windowActivate. This event obsoletes the auto_activate() sub
addinInstall
addinUninstall
afterRemoteChange
afterSave This piece of VBA code demonstrates how this event can be used to export a workbook's worksheets as CSV when the workbook is saved.
afterXmlExport
afterXmlImport
beforeClose There is no afterClose event. beforeClose is fired before the deactivate event. Does this event obsolete auto_close()?
beforePrint
beforeRemoteChange
beforeSave
beforeXmlExport
beforeXmlImport
deactivate deactivate is fired after the beforeClose event (and also after the windowDeactivate event). This event obsoletes the auto_deactivate() sub
modelChange
newChart
newSheet
open This event obsoletes the auto_open() sub. If both, the event and the function, are present, the event is triggered before auto_open is called.
pivotTableCloseConnection
pivotTableOpenConnection
rowsetComplete
sheetActivate
sheetBeforeDelete
sheetBeforeDoubleClick
sheetBeforeRightClick
sheetCalculate
sheetChange fires when content in a Range has changed. Compare with the selectionChange worksheet event.
sheetDeactivate
sheetFollowHyperlink
sheetLensGalleryRenderComplete
sheetPivotTableAfterValueChange
sheetPivotTableBeforeAllocateChanges
sheetPivotTableBeforeCommitChanges
sheetPivotTableBeforeDiscardChanges
sheetPivotTableChangeSync
sheetPivotTableUpdate
sheetSelectionChange
sheetTableUpdate
sync deprecated
windowActivate
windowDeactivate windowDeactivate is called before deactivate
windowResize

See also

Order of events
application.enableEvents controls whether an event triggers the corresponding event procedure.
Events of the worksheet object
workbook.runAutoMacros

Index