ID: Q184255
The information in this article applies to:
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.
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
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
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:
ARTICLE-ID: Q176476
TITLE : OFF: Office Assistant Not Answering Visual Basic Questions
Keywords : kbdta xlvbainfo xlvbmigrate
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbhowtoLast Reviewed: April 25, 1998