I currently operate 100+ excel spreadsheets each spreadsheet has a macro into to run when the workbook opens and when the workbook close.
I then have a seperate mointioring file which monitors the 100+files, and in this file I have a macro which opens all the files and closes them for updating purposes
My problem is I dont want the workbook open and workbook close macro to work if I am running the update macro!
Make any sense ? Please help
Bookmarks