Stop WorkbookOpen and WorkbookBeforeClose Macros
Posted by Zif on June 07, 2000 3:49 AM
I have a number of departmental "input" spreadsheets that are completed on a daily basis. These sheets have both a WorkbookOpen and a WorkbookBeforeClose macro that do various things including checking that all cells in the spreadsheet have been completed.
I have another spreadsheet with a macro that opens each of the "input" files each afternoon, copies the data to a "historic" file, clears the previous data and then saves and closes the "input" files.
What I would like is for the Open and Close macros to run whenever the departments access the files, but when I open the files using my "copy and clear" macro for the Open and Close macros to be temporarily disabled.