Excle ribbon: how to create three tabs with a common title on top

[lalbatros]

Hello,

My Excel vsto Workbook project needs three tabs.
On top of the three tabs, I would like to see a "large tab" with some color and some title.
This is similar to the built-in "PIVOTCHART TOOLS" or the "PIVOTTABLE TOOLS", which makes things more readable.

Unfortunately, I did not see any way to do that.
I found no way to do it in the designer in Visual Studio.
I found no property of method that could do it in the initialization code.

Do you think this could be possible?

Thanks for your suggestions,

Michel

 

[Michael M]

Only if you have Excel 2010 or higher


https://support.office.com/en-us/article/Customize-the-ribbon-3c610b47-6f0f-4179-83d3-68a254a80ea6

 

[lalbatros]

Thanks Michael,

It's already good that I know about this.

However, my tabs do not appear in this list.
This is probably because these tabs are dedicated to my specific Excel Workbook project.
I have observed that the tabs related to an Excel addin project do indeed appear in this list.
Bad luck!
I had spent quite some time before deciding between addin and workbook project and chose the workbook for several good reasons.

Nevertheless, I would also be interested to learn if these customizations could be performed in VBA.
If they can I could do the same in C# vsto.

Thanks,

Michel

 

[lalbatros]

I just learned that what I am looking for is called "contextual tabs".
This name does not refer to the "common title" share by the tabs,
but to the fact that they appear only when a certain context occurs.

Maybe this can help to find a solution!

Michel

 

[RoryA]

AFAIK, it is not currently possible to create those tab groups.