Event Sequences

Events occur in response to specific actions and occur in a predefined sequence. The table below demonstrates the sequence of events while opening a new workbook, adding a new worksheet to a workbook, and closing the workbook.

Action

Object

Event Sequence

Opening a new workbook

Workbook

NewWorkbook, WindowDeactivate, WorkbookDeactivate, WorkbookActivate, WindowActivate

Inserting a new sheet into a workbook

Workbook

WorkbookNewSheet, SheetDeactivate, SheetActivate

Closing a workbook

Workbook

WorkbookBeforeClose, WindowDeactivate, WorkbookDeactivate, WorkbookActivate, WindowActivate

0 0

Post a comment