I've created a few macros in a workbook. The macros import and then format
the sheet and data the way I need it to be and they all work great.
What I would like is a macro that will prompt the user to save the workbook
as another file name (prompt for location and file name). Once the new
workbook is saved, how do I close the original file without actaully saving
the data in it. (Basically, the file I open is like a template that should
never be changed)

Secondary question....is there a way, when saving as a new file name, to
remove the background macros in the new file or disable them so that another
user of the file does not get the "enable/diable macros" prompt when opening
the new file?

Thanks for the help.