Macros in Ribbon error

[jeetkapadia]

I have some macros in a custom ribbon tab and it seems that excel takes the location of those macros based on the current directory location of the file. So if I were to move the file to a different folder, it cannot locate the macro and it breaks. Is there any way around this?

[6StringJazzer]

One way around it is to put the macros in a different file that will always be in the same place. I keep my ribbon macros in PERSONAL.xlsb. Another option is to create an add-in from the file containing your macros, although you would have to repeat that process every time the macros change.

But there is no way to move a file and automatically have the Ribbon button find the macro in the new location.

[jeetkapadia]

I solved the problem and there actually is a way. You can export customizations, and in that file, change all the places with Location\MacroName to MacroName and then import it again. Works well for me.

[6StringJazzer]

Glad you found a way that works for you. The customizations file is an XML file that you can edit but it's not really intended for human consumption so you have to be careful.