How to move custom VBA/ribbons

[missingsc]

I posted a similar thread some time ago and unfortunately didn't understand the answer given at the time. Hoping to start a fresh discussion on how to do this...

I have a custom spreadsheet I've built containing VBA subs/functions and forms. To interact with that functionality, I've also modified the Ribbon for new buttons to run those functions as needed. I want to be able to reuse this spreadsheet and give it to others. The problem I've run into is multi-fold:

• The customized Ribbon isn't sent with the spreadsheet by default. I need to export the customizations and ask the user to load them. Can that be somehow done automatically?
• The custom VBA and forms are not sent with the spreadsheet. The only way I've found to send them is with an Add-In, which the user then has to load manually.
• When the Ribbon customizations are loaded, the buttons do not work. They error out saying the sub/function cannot be found because a file path/url cannot be found. I have to delete the button, then recreate it and link it to the sub/function/macro by hand.

Obviously the question is how can this be done so the user doesn't have to do anything? They just get the spreadsheet and it's ready to go? Failing that, how close can we get to making it automatic for them? At worst, I'd like to be able to send them the Add-In and Ribbon Customization file with instructions on how to load it, but as said that doesn't work either.

Looking forward to all the answers you have as I'm stuck being able to share this with anyone. Thank you in advance!

 

[Micron]

So your solution was to use the QAT or customize/build your own ribbon?

 

[RoryA]

Glad we could help.

 

[missingsc]

So your solution was to use the QAT or customize/build your own ribbon?

I went with the customized Ribbon. I had been using it on my machine for quite some time now so I didn't want to lose that functionality. Really glad it worked, and again thank you so much for helping me with the solution!