Home |
Search |
Today's Posts |
#1
|
|||
|
|||
application.EnableEvents
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|