Microsoft Office Tutorials and References
In Depth Information
Monitoring with Application Events
Creating event-handler procedures to handle Application events always requires a
class module and some setup work.
Table 19-4 lists the commonly used Application events with a brief description of each. Excel
2010 added a few new events that deal with protected view windows and pivot tables. Consult
the Help system for details.
Table 19-4: Commonly Used Events Recognized by the Application Object
Event
Action That Triggers the Event
AfterCalculate
A calculation has been completed and no outstanding queries exist.
NewWorkbook
A new workbook is created.
SheetActivate
Any sheet is activated.
SheetBeforeDoubleClick
Any worksheet is double-clicked. This event occurs before the default
double-click action.
SheetBeforeRightClick
Any worksheet is right-clicked. This event occurs before the default
right-click action.
SheetCalculate
Any worksheet is calculated (or recalculated).
SheetChange
Cells in any worksheet are changed by the user or by an external link.
SheetDeactivate
Any sheet is deactivated.
SheetFollowHyperlink
A hyperlink is clicked.
SheetPivotTableUpdate
Any pivot table is updated.
SheetSelectionChange
The selection changes on any worksheet except a chart sheet.
WindowActivate
Any workbook window is activated.
WindowDeactivate
Any workbook window is deactivated.
WindowResize
Any workbook window is resized.
WorkbookActivate
Any workbook is activated.
WorkbookAddinInstall
A workbook is installed as an add-in.
WorkbookAddinUninstall
Any add-in workbook is uninstalled.
WorkbookBeforeClose
Any open workbook is closed.
WorkbookBeforePrint
Any open workbook is printed.
WorkbookBeforeSave
Any open workbook is saved.
WorkbookDeactivate
Any open workbook is deactivated.
WorkbookNewSheet
A new sheet is created in any open workbook.
WorkbookOpen
A workbook is opened.
 
Search JabSto ::




Custom Search