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?