Disable a Macro
Glad top help.
Darren
On Fri, 16 Dec 2005 01:04:47 -0000, Dave wrote:
Thanks Darren - Worked a treat. I was searching the HELP for "disable"
Dave.
"Darren Hill" wrote in message
news:op.s1umxakped89cl@omega...
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
On Thu, 15 Dec 2005 23:32:22 -0000, Dave
wrote:
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
--
------------------
Darren
|