Application.EnableEvents

This property can be set to False to prevent the application from raising any of its events.
Do not even be tempted to use this as your code will never be the only code running and other developers will have created add-ins or code behind solutions that will rely on events being fired.
If you want to prevent your event from running there are several options:
1) stop listening for the event
2) Create a guard variable that is checked before the event is fired.


Excel

Do not even be tempted to use this as your code will never be the only code running and changing this will have an effect on other add-ins that might be installed.


Word

The method Application.EnableEvents does not exist in Word.


PowerPoint

The method Application.EnableEvents does not exist in PowerPoint.



© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext