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
Action That Triggers the Event
A calculation has been completed and no outstanding queries exist.
A new workbook is created.
Any sheet is activated.
Any worksheet is double-clicked. This event occurs before the default
Any worksheet is right-clicked. This event occurs before the default
Any worksheet is calculated (or recalculated).
Cells in any worksheet are changed by the user or by an external link.
Any sheet is deactivated.
A hyperlink is clicked.
Any pivot table is updated.
The selection changes on any worksheet except a chart sheet.
Any workbook window is activated.
Any workbook window is deactivated.
Any workbook window is resized.
Any workbook is activated.
A workbook is installed as an add-in.
Any add-in workbook is uninstalled.
Any open workbook is closed.
Any open workbook is printed.
Any open workbook is saved.
Any open workbook is deactivated.
A new sheet is created in any open workbook.
A workbook is opened.