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 event2) 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.