Expand Minimize

Application.EnableEvents Property (Excel)

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

expression .EnableEvents

expression A variable that represents an Application object.

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
Show:
© 2015 Microsoft