Excel: Carry a Ribbon when it is sent

[SteveOranjin]

Hello,

I have been working with a sheet for sometime now, and I've been able to configure a data sheet that has lots of macros. I've been using a seperate sheet within the data sheet to activate macros, but it occurred to me to make my own ribbon instead.

Is there a way to ensure that the ribbon I've created stays in tact when I send it and the accompanying macros?

Hope you are well,

Steve

 

[Jerry Sullivan]

Hi Steve,

If you store the RibbonX customizations and the associated VBA code inside the workbook, that custom ribbon should work for other people the same way that it works for you provided they are using a version of Excel that supports your RibbonX code.

 

[SteveOranjin]

Hi Jerry,

I'm not sure I know what ribbonX is. I'm not sure I know how to ensure that a ribbon is saved inside the workbook either.

 

[RoryA]

This is a good place to start with what Jerry is referring to: http://www.rondebruin.nl/win/section2.htm