Event Driven Macros stop running after running a routine macro

I have a button set up with a macro to clear all the input cells (a named range) on the sheet.

After I run this my event driven macros (specifically Worksheet_Change) doesn't run.

Has anyone run into this before?

Specific example, I run this

Please Login or Register  to view this content.

and this stops working

Please Login or Register  to view this content.

Change event works fine until I run the first macro.

Hi,

The "Application.EnableEvents = False" must be paired with "Application.EnableEvents = True", otherwise after the very first time the sub is run (which means EnableEvents = False), Excel will continue in this state, make it not responding to any event.

I suggest the sub will be like this :

Please Login or Register  to view this content.

You may need to run this sub first, in case current EnableEvents state is False :

Please Login or Register  to view this content.