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?

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 <8E65B43B-08C5-470E-AE35-F292E36D8D53@microsoft.com>,
"nc" <nc@discussions.microsoft.com> 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?