Globally change path of assigned macros when using .xlam files

69 Views Asked by At

I have a suite of macros which I save in an .xlam file for easy transport to other users, which is saved at C:\Users\User\AppData\Roaming\Microsoft\AddIns. I also export a ribbon containing a customised menu and icons to which I have assigned the macros.

What I cannot find is a way to update the path in the assigned macros. In this case the ribbon holds the old path with my name as the user. I then have to reassign the macros, one by one, with the new path when I would like to just globally change the (User) name. I may be missing something obvious but any workarounds or suggestions would help.

0

There are 0 best solutions below