편집

다음을 통해 공유

Application.EnableEvents property (Excel)

  • 아티클

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

Syntax

expression.EnableEvents

expression A variable that represents an Application object.

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.