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
Bookmarks