Using Events with Microsoft Excel Objects [Excel 2003 VBA Language Reference]

You can write event procedures in Microsoft Excel at the worksheet, chart, query table, workbook, or application level. For example, the Activate event occurs at the sheet level, and the SheetActivate event is available at both the workbook and application levels. The SheetActivate event for a workbook occurs when any sheet in the workbook is activated. At the application level, the SheetActivate event occurs when any sheet in any open workbook is activated.

Worksheet , chart sheet , and workbook event procedures are available for any open sheet or workbook. To write event procedures for an embedded chart , QueryTable object, or Application object, you must create a new object using the WithEvents keyword in a class module.

Use the EnableEvents property to enable or disable events. For example, using the Save method to save a workbook causes the BeforeSave event to occur. You can prevent this by setting the EnableEvents property to False before you call the Save method.

Application.EnableEvents = False
ActiveWorkbook.Save
Application.EnableEvents = True

See Also | Application Object Events | Chart Object Events | Control and Dialog Box Events | Using Events with Embedded Charts | Using Events with the Application Object | Workbook Object Events | Worksheet Object Events