Event Order


Opening Excel

NO EVENTS are fired in .NET if the "Analysis-ToolPak VBA" add-in is not installed
Application - WorkbookOpen
Application - WindowDeactivate
Application - WorkbookDeactivate


If you are opening up a blank workbook
Application - NewWorkbook
Workbook - Activate
Application - WorkbookActivate
Workbook - WindowActivate
Application - WindowActivate


Closing Excel

Application - WorkbookBeforeClose (this event is fired for any Excel add-ins that are installed or hidden workbooks)
Workbook - BeforeClose


New Workbook

Application - NewWorkbook
Workbook - Activate
Application - WorkbookActivate
Workbook - WindowActivate
Application - WindowActivate


Opening a Workbook

Workbook - Open
Application - WorkbookOpen
Workbook - Activate
Application - WorkbookActivate
Workbook - WindowActivate
Application - WindowActivate


Closing a Workbook

Workbook - BeforeClose
Application - WorkbookBeforeClose
Workbook - WindowDeactivate
Application - WindowDeactivate
Workbook - Deactivate
Application - WorkbookDeactivate


Selecting Cells

Worksheet - SelectionChange
Workbook - SheetSelectionChange
Application - SheetSelectionChange


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext