Store custom ribbon (which calls macros) in workbook for other users when they open the workbookexc

[FleetwoodMacro]

I have created a custom ribbon in a workbook in Excel 2013. Each of the buttons on the ribbon calls a different macro, which generally displays some form for data entry that can call other macros, etc. I want this ribbon and the macros to be accessible to other users of this workbook who have saved it on their machine or a different drive.
I am having a lot of confusion with dealing with the "exportedUI". I understand that I can export the custom ribbon settings as an XML file. Testing from my own machine, if I copy the workbook to my desktop and then import the custom UI file, the ribbon appears but the macros will not run (I get the "Cannot run the macro "[path of the original file]![macro name]. The macro may not be available in this workbook or all macros may be disabled." error). Looking at the custom UI XML and from seeing that error message, the custom UI file is obviously still pointing to the original workbook and not my copy of the workbook.
Thus, I have 2 questions:

1. How can I modify this custom UI to point to THIS workbook which is opening it?
2. How can I modify the workbook settings such that another user automatically sees this ribbon upon opening the workbook and does not have to import it himself/herself?

Any insight would be appreciated! I have been searching through various threads for the past few hours and haven't quite found what I'm looking for. Thanks in advance.

 

[Smitty]

Welcome to the Board!

Why can't you just send the workbook?

If you want the menu and code to be accessible regardless of which workbook you have open you'd need to distribute as an add-in. See: Creating An XLA Add In

 

[FleetwoodMacro]

Welcome to the Board!

Why can't you just send the workbook?

If you want the menu and code to be accessible regardless of which workbook you have open you'd need to distribute as an add-in. See: Creating An XLA Add In

If I send the workbook, the user on their end won't have access to the custom ribbon UI. If I send them the UI as well and they import it, the XML in the UI will still point to the full path name of the original workbook on my desktop, so the ribbon buttons won't be calling macros from that user's copy of the workbook.