Microsoft KB Archive/213220

= XL2000: Summary of Workbook and Worksheet Application Events =

Article ID: 213220

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213220



For a Microsoft Excel 2002 version of this article, see 291294.

For a Microsoft Excel 97 version of this article, see 161761.



SUMMARY
This article includes a summary of Visual Basic for Applications workbook and worksheet events and each corresponding command used in versions of Microsoft Excel earlier than Microsoft Excel 97.



Workbook Events
                     Previous version Event name        equivalent         Description of when event fires - -

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 opens.

BeforeClose       Auto_Close         Before the workbook closes.

AddInInstall      Auto_Add           When the user installs the add-in through the add-in manager.

AddInUninstall    Auto_Remove        When the user uninstalls the add-in through 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 comes to a                                         window belonging 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 in the workbook.

SheetBefore       OnDoubleClick      When a worksheet cell is double- DoubleClick                          clicked. SheetSelection    N/A                When there is any change in cell Change                               selection on a particular sheet. SheetBefore       N/A                When a worksheet cell is right- RightClick        N/A                clicked.

SheetChange      OnEntry             When a user changes the formula of a cell by typing, copy or                                        paste, drag or drop, or undo.

Worksheet Events
                     Previous version Event name        equivalent         Description of when event fires - -  ---

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. Fires 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, copy or                                        paste, drag or drop, or undo.

