I have a spreadsheet that I made on my personal computer that contains many simple macros that hide columns. I have the macros assigned to buttons in the ribbon that I customized. I just copied my spreadsheet to my network at work, and I'm having issues running the macros from the spreadsheet on my network by clicking the buttons they're assigned to. I end up getting the following message:

"Cannot run the macro "path.macro name". The macro may not be available in the workbook or all the macros may be disabled."

Where the path is the desktop of my personal computer and the macro name is the macro that hides columns. I have macros enabled on this spreadsheet while operating it on my personal computer and my work one. I can get the macros to run by clicking the "macros" button on the "developer" tab and choosing one from the list that pops up, but it will not work by clicking the button. I can tell that it's looking for the path that's unavailable (spreadsheet originated from my computer which doesn't exist on my work computer).

What's the best/easiest way to fix this? Can I just tell Excel to look for the macro within the path the my spreadsheet exists on my work computer? Is this a macro issue or an issue with customizing the ribbon or both? I've found that if I re-add the macro to a button on the ribbon while on my work computer, then the macro works again, but I have a lot of macros... I'd rather avoid doing that for all of them, and there's got to be a "correct" way to fix this issue.