Microsoft KB Archive/184255

= XL98: Summary of Workbook and Worksheet Application Events =

Article ID: 184255

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q184255



SUMMARY
This article includes a summary of Visual Basic for Applications workbook and worksheet events and the corresponding commands that are used in earlier versions of Microsoft Excel.



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

