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.
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:
176476 OFF: Office Assistant Not Answering Visual Basic Questions
Additional query words: XL98 fires firing
Keywords: kbhowto KB184255