XL98: Summary of Workbook and Worksheet Application Events

MORE INFORMATION

Workbook Events

                    Previous version
 Event name         equivalent         Description of when event occurs
 ----------------------------------------------------------------------

 Activate           Auto_Activate      When the active workbook changes
                                       from another workbook to this
                                       workbook

 Deactivate         Auto_Deactivate    When the active workbook changes
                                       from this workbook to another
                                       workbook

 Open               Auto_Open          When the workbook is opened

 BeforeClose        Auto_Close         Before the workbook is closed

 AddInInstall       Auto_Add           When the user installs the Add-In
                                       via the Add-In manager

 AddInUninstall     Auto_Remove        When the user removes the Add-In
                                       via the Add-In manager

 WindowResize       N/A                After a window of the workbook has
                                       been opened, resized, maximized, or
                                       minimized

 WindowActivate     OnWindow           Every time the focus moves to a
                                       window that belongs to the workbook

 WindowDeactivate   OnWindow           Every time the focus leaves this
                                       particular window of the workbook

 BeforeSave         OnSave             Before a workbook is saved

 BeforePrint        N/A                Before a workbook is printed

 NewSheet           N/A                After a new sheet is created

 SheetActivate      OnSheetActivate    Every time a Sheet is activated in
                                       the workbook.

 SheetDeactivate    OnSheetDeactivate  After a Sheet is deactivated in the
                                       workbook

 SheetCalculate     OnCalculate        After any recalculation occurs in
                                       the workbook

 SheetBefore
 DoubleClick        OnDoubleClick      When a worksheet cell is double-
                                       clicked

 SheetSelection
 Change             N/A                When there's any change in cell
                                       selection on a particular sheet

 SheetBefore
 RightClick         N/A                When a worksheet cell is right-
                                       clicked

 SheetChange        OnEntry            When a user changes the formula
                                       of a cell by typing, copying and
                                       pasting, dragging, or undoing
				

Worksheet Events

                    Previous version
 Event name         equivalent         Description of when event occurs
 ----------------------------------------------------------------------

 Activate           OnSheetActivate    When the active sheet changes
                                       from another sheet to this sheet


 Deactivate         OnSheetDeactivate  After the active sheet changes from
                                       this sheet to another sheet; occurs
                                       before the activated sheet is
                                       displayed

 Calculate          OnCalculate        After every recalculation of this
                                       sheet

 BeforeDoubleClick  OnDoubleClick      When a worksheet cell is double-
                                       clicked

 SelectionChange    N/A                When a worksheet cell is clicked

 BeforeRightClick   N/A                When a worksheet cell is
                                       right-clicked

 Change             OnEntry            When a user changes the formula
                                       of a cell by typing, copying and
                                       pasting, dragging, or undoing