That's what's happening now, unless the macro specifically deletes the
code in the template.

If that code exists, delete it.

In article . com,
wrote:

I have a macro that is run in a workbook that is the master copy.
When the macro runs I have the user enter a new name to save the
file. Once this happens the original macro is transferred to the new
file, is there a way to protect this code so that it stays in the
master copy and also transfers to the new workbook as well?