XL98: Summary of Workbook and Worksheet Application Events

• Microsoft Excel 98 Macintosh Edition

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.

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
 

REFERENCES

For more information about workbook or worksheet events, from the Visual Basic Editor, click the Office Assistant, type events, click Search, and then click to view "Workbook Object Events."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:

Q176476 OFF: Office Assistant Not Answering Visual Basic Questions

Additional query words: XL98 fires firing

Keywords : kbdta xlvbainfo xlvbmigrate
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowto