My macro is written in a workbook called BLANK WORKBOOK.xls.
When this macro is run it does a SaveAs because sheets are going to be
added and it needs to be saved as a separate name.
The BLANK WORKBOOK is a template that needs to be used several times
however when the code does a SaveAs the macro is trasferred to the new
work book.
How do I keep the macro in the master BLANK WORKBOOK but also will be
able to have the macro run locally in the new workbook as well?