EnableEvents Property

True if events are enabled for the spreadsheet or the chart workspace. Read/write Boolean.

expression   Required. An expression that returns one of the objects in the Applies To list.

Example

This example prevents spreadsheet event procedures from running.

Spreadsheet1.EnableEvents = False