Disable a Macro

[Dave]

I have a macro that runs automatically every time certain cells are changed
I also have an "update" macro which I run manually.
Is there code I can put into the "update" macro that disables the automatic
macro, allowing the "update" routine to run unimpeded, then insert another
line of code to re-enable the automatic macro?

Dave.

 

[Darren Hill]

application.EnableEvents = false

then at the end of your code:
application.EnableEvents = true

You might also need to use
application.calculation = xlmanual

followed by (at the end of the code)
application.calculation = xlautomatic

 

[Dave]

Thanks Darren - Worked a treat. I was searching the HELP for "disable"
Dave.

 

[Darren Hill]

Glad top help.

Darren

Thanks Darren - Worked a treat. I was searching the HELP for "disable"
Dave.