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
|