disable macro during save-as
I have a macro in ThisWorkbook in a workbook named Template, that will
make sure a column is cleared before the user starts. This, in case
someone saves data in this workbook by accident.
The user will run other macros, and eventually a macro will save this
workbook under a new name based on the date, example NewFile 1-1-07 .
However, if the user brings up this workbook NewFile 1-1-07 again
later, this column will be wiped out via the ThisWorkbook coding.
What I want is to include code within the macros that will disable the
code in ThisWorkbook so that column is not wiped out when it is opened
later.
Thanks,
J.O.
|