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.