You can't. With .EnableEvents set to false, events won't fire, and their
corresponding event macros won't run.
Just don't forget!
You can always enter
application.enableevents = true
in the immediate window of the VBE. You could even create a macro to run
that line of code.
In article ,
"nc" wrote:
When using the above keyword and setting it to False with a worksheet change
event. How can I run my macros using worksheet change event, if I forget to
reset it to True?
|