Create Ribbon but for only a single excel workbook

Hi Guys,

Is there a way to make a a new ribbon (like "Home" or "Insert"), but have custom ribbon only appear within a particular excel sheet.

eg, have a custom ribbon per excel document/worksheet?

if there is a way, how do i do this?

thanks!

You need to use the getVisible callback of the Tab.

Set up the customui xml.

VBA code to set a reference to the ribbon, so you can Invalidate it and get the callback to be called.
You will also need a class object with events exposed to the Application. If you catch the SheetActivate event you can Invalidate the ribbon.

In this example SHEET2 will display the new Tab 1 on the ribbon.

that is interesting what you have done.

How do I insert a sub() into the ribbon as a button?

And how do i make "Group1", "Group2" and rename them.
and rename "button1"?

The construction of the ribbon is done use xml, stored within the customUI section of the zipped workbook file.

You will find a bunch of information here.
https://www.contextures.com/excelrib...customtab.html