View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?