I have a beginners knowledge of VBA macros in Excel 2007. I have developed a beforesave VBA macro for excel 2007 that checks that a number of cells have non-blank, non-zero values in them to force users to complete certain cells before saving. This seems to work quite well The workbooks are used to feed into a Word Mail Merge and it saves incomplete letters being sent out.
My catch is with me saving the file. How do I save master copies of this workbook with the cells left blank or zero (the default) and hence override or bypass or ignore the beforesave macro? This is primarily while I am developing and testing the new excel workbook and so I can send out master copies to the other users.
Bookmarks