How can I get rid off my path on other user's workstations?

[Gabriel1979]

Hello,

I shared my macros to other users as a package with User Interface, but when they need to run them, it says that it cannot be run because of the username in the path.

error.png

Can somebody help me please to pass the error?
I don't want to send an email to explain them how to manually add the macros, or to add them myself via remote control.
Than you in advance!

[rorya]

You would be better off creating an add-in with a custom ribbon. Sharing a personal macro workbook is not recommended.

[Gabriel1979]

Hello,

I recreated the macros as Add-ins this time, but the error is the same...
Where is that setting that gets rid of my local path...?

addins.png

Thank you!

[rorya]

Then you must not have created a custom ribbon for it. That would not include paths - see here: https://www.rondebruin.nl/win/section2.htm

[Gabriel1979]

Hello,

OK!
I will create an extended install guide to explain everybody how to create the same custom ribbon. Thank you!

[rorya]

If you do what that article says, your users won't have to do anything other than open/install the add-in as normal. The ribbon customisations are stored in the add-in workbook itself and will appear automatically for them.