Hi
Is it possible to take the path out of a macro reference I have added to the Quick Access Toolbar?

I work on two machines in different locations but they both open a copy of the same macro file - mymacros.xlsm - which is automatically updated across our network. But the paths from each machine is different. I have a macro button on my quick access toolbar but when I add the macro it stores the full address. Thus from machine 1 the macro reference is

\\server1\mydir\mymacros.xlsm!macro1

and from the other machine is

\\server2\newpath\mydir\mymacros.xlsm!macro1

Thus depending on which machine I am using the reference is invalid in one of them.

Assuming I always have mymacros.xlsm open can I just get the quick access toolbar to reference

mymacros.xlsm!macro1?

That is - strip out the path reference.

Thanks

Max