XL2000: Summary of Workbook and Worksheet Application Events

This article was previously published under Q213220
This article has been archived. It is offered "as is" and will no longer be updated.
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 workbookand worksheet events and each corresponding command used in versions of Microsoft Excel earlier than Microsoft Excel 97.
More information

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.				
References
For more information about workbook events, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type workbook object events in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about worksheet events, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type worksheet object events in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Properties

Article ID: 213220 - Last Review: 10/26/2013 18:05:00 - Revision: 4.0

  • Microsoft Excel 2000 Standard Edition
  • kbnosurvey kbarchive kbhowto kbinfo KB213220
Feedback