Forum Discussion

Swan_Intel's avatar
Swan_Intel
Copper Contributor
Sep 29, 2022

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