Forum Discussion
Swan_Intel
Sep 29, 2022Copper Contributor
Macro keeps pointing to my computer instead of the xlsm file
I created 2 new macros and I assigned them to 2 buttons on the customized ribbon. However, when I exported the exportedUI file and send both files over to my colleague, she could not run the macros by using the buttons.
It looks like the buttons point to a macro on the file from my computer.
Example:
My file is called "My_Macro.xlsm". I have 10 macros.
8 of them have the path: My_Macro.xlsm!Macro1 and so on.
The 2 new that I created show: https://company .sharepoint.com/personal/mycomputer/My_Macro.xlsm!Macro9
I want them to have the link like the other 8 (My_Macro.xlsm!Macro1).
Thank you!
No RepliesBe the first to reply