Ribbon tool

[webluca]

Hello all,

do you know how to add a Ribbon tab like the ones that apper when selecting a Chart or a pivot. I don't know how is it called a tab like this...

I need to create such tab in my addin when user select a certain worksheet.

I already know ho to create a new Ribbon using Custom UI Editor.


Thanks

Cattura.jpg

[Paul_Hossler]

That's a "Context Menu" but I don't think you can add your own; I think you have to modify built in ones


Ron de Bruin has a nice write up with examples


http://www.rondebruin.nl/win/s2/win003.htm

and

http://www.rondebruin.nl/win/s2/win014.htm


Capture.JPG

1. These is one called "ContextMenuWorkbookPly" which is the one that right-clicking on the worksheet tab name will bring up. You could add to that one, or

2. Just create your own 'normal' ribbon tab and make it visible or not depending on if your special worksheet is active

Personally, I'd go with #2 since it's more 'standard'

[Aflatoon]

To be pedantic, it's a contextual tab, rather than a context menu (which are the right-click menus only): http://www.rondebruin.nl/win/s2/win006.htm

[webluca]

Ok, by knowing the name I found all that i need, and it seems is not possible to create a contextual tabe that is shown when a particular sheet is open. The contextual menu are preset on object like chart, pivot, table, ....
So maybe the best and only solution is the one suggested by Paul: "Just create your own 'normal' ribbon tab and make it visible or not depending on if your special worksheet is active"

Thanks fro your help

[Paul_Hossler]

To be pedantic, it's a contextual tab, rather than a context menu (which are the right-click menus only): http://www.rondebruin.nl/win/s2/win006.htm

Thanks for the correction

You are correct of course, and I was having a "senior moment"