I have a "Master" Excel template ".xlt" that contains macros to create,
format and protect a new worksheet.

After the "Master" "xlt" file is opened, and used to create, format,
and protect a worksheet, the macros are no longer needed or wanted in
the new "xls" file (but the macros are still wanted and needed in the
"Master" "xlt" file). How do you save the resulting "xls" file,
keeping the formatting and worksheet protection, without the "Master"
template's macros?

Is there a macro that can be created, that will not save the macros in
the "xls" file, but will keep the macros in the "Master" template "xlt"
file?


--
nulad
------------------------------------------------------------------------
nulad's Profile: http://www.excelforum.com/member.php...o&userid=33248
View this thread: http://www.excelforum.com/showthread...hreadid=530713