All,
Is it possible to code a pause in some code based on another macro being executed.
I've got the following piece of code in a worksheet ("input") to protect it:
however when I kick off a macro on the input sheet, which is called Refresh_for_Current_Month it won't update because of the above code locking the sheet.
Obviously I would normally just write a lock and unlock into the Refresh macro but this doesn't work as there is the need for some other code in the same worksheet to allow the user to drill down into some source data.
What I ideally need is a line of code to say Pause if the Refresh_for_Current_Month macro is running...any ideas how?!
Thanks as always
NKO
Bookmarks