EnableEvents Property

Microsoft Excel Visual Basic

EnableEvents Property

       

True if events are enabled for the specified object. Read/write Boolean.

Example

This example disables events before a file is saved so that the BeforeSave event doesn’t occur.

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