Macro name shorter
 

Hi,

How do I make the macro name in such a way that it does not have the
spreadsheet name included when I go and look Tools/ Macro/Macro

The problem comes when I copy save as a different file name and then when I
try to run the macro tells me it cannot find the macro.

Example. Have a spreadsheet called Template.xls. Now split into Template
A-M.xls and Template N-Z.xls and the macros I created in Template.xls now do
not work in the two new spreadsheets.

Thanks