Excel: Carry a Ribbon when it is sent

SteveOranjin

Board Regular
Joined
Dec 18, 2017
Messages
170
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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,162
Messages
6,170,432
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top