Can we customize the Ribbon at run time ?

[Jaafar Tribak]

Like adding a custom commandbar button and/or removing it dinamically via VBA code just like with xl 2003 and earlier .

Thanks.

 

[Jaafar Tribak]

Ok let me see if I can explain this better.

It is not an actual button that i am looking to dinamically add to and remove from the Ribbon , rather it is a custom tab that I want to be able to add/remove or toggle its Visible Property.

I know one can toggle the Visible Attibute of a Button within a Tab via the getVisible attribute defined in the CustomUI.xml code such as:

getVisible="Button1_Visible"/>

and then the VBA callback as follows :

Sub Button1_Visible(control As IRibbonControl, ByRef returnedVal)
    returnedVal = boolResult
End Sub

Question:

Can we toggle the visible Attribute/Property of an entire custom tab as opposed to a control within the tab ?

I 've done some searching but no luck so far.

 

[Jaafar Tribak]

just bumping this thread.

 

[xenou]

Just trying to follow some examples here (seems to be saying yes):
http://msdn.microsoft.com/en-us/library/bb545350(v=office.12).aspx

Also I'm using the starter tutorial here (to get my feet wet):
http://www.xtremevbtalk.com/showthread.php?t=265636#

Though I'm still fighting with the ribbon code to get the effect too ...

 

[xenou]

This looks even better but I admit I'm defeated for the night. I did succeed in making a tab disappear entirely!

http://msdn.microsoft.com/en-us/library/ee390805(v=office.11).aspx

Also a more recent link for the CustomUIEditor.exe (for 2010 or 2007):
http://msdn.microsoft.com/en-us/library/ee390805(v=office.11).aspx

 

[xenou]

One more note: Ron's site (linked in the page on my last post) has sample workbooks, of which one demonstrates showing/hiding a tab:
http://www.rondebruin.nl/hidevisible.htm

 

[Jaafar Tribak]

xenou.

Thank you very much for all the links.

I too did manage to toggle the visible attribute of the custom tab in the end.

 

[Johnny C]

Another question:
I want to open a hidden workbook (akin to personal.xlsb where Sheet1 is Hidden). Can I keep a custom ribbon that opens up with it when I hide Sheet1?

Normally when you hide any open sheets on a workbook the custom ribbons that the workbook opens hide away.