View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelnut1954 excelnut1954 is offline
external usenet poster
 
Posts: 175
Default 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.