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.

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

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

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