Microsoft Office Tutorials and References
In Depth Information
Table 12-3 describes the commonly used Application events that can be programmed in your
Table 12-3. Commonly Monitored Events by the Application Object
Action That Triggers the Event
Monitors the NewWorkbook event for the Excel application.
The event is triggered when a new workbook is created.
Monitors the SheetActivate event for the entire Excel program. The
event is triggered when any sheet is activated within the program.
Monitors the WorkbookOpen event for the Excel application.
The event is triggered when any workbook is opened within the
Locate Events Using the Object Browser
The Object Browser is a useful tool that can help you learn about objects, their properties,
and their methods. The Object Browser is also useful when trying to find which objects are
supported by a particular event. For example, say you would like to find out which objects
support the Change event. Activate the Visual Basic Editor, and press F2 to display the
Object Browser window. Make sure <All Libraries> is selected, and then type Change and
click the binoculars icon, as shown in the following graphic.