Hi,

I have an excel template that is macro enabled. However, when I save a new copy of the template under a different file name the macros are still linked to the original template name, is there a way to ensure that when a copy of the template is saved that the macros automatically update to that new file name and thus still work?

Many thanks,

Jaymie