Is it possible to prevent code in the Sheet Activate event from running
when another macro makes the sheet visible to perform another task?

I have code that copies the sheet when certain criteria is met on that
sheet when it is activated or made visible, however on occassion i need
to make that sheet visible for another task via another macro but when
it is made visible ifthe criteria is met it makes a copy....which at
this point is an undesired effect, is there any way to prevent this
from happening?

regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=553529