Office 2007 get ribbon name

J

Jwh

I am working on an app with a custom menu on the Add Ins ribbon. I have
figured out how to hide the whole ribbon, but how do I get the name/ids of
the tabs on the ribbon, when I am not currently using XML to generate this
ribbon.
Ideally, I would like to get the ids for each specific tab so I can turn all
tabs except for the add ins tab off.

Many Thanks,
 
R

Ron de Bruin

Hi Jwh

This will hide all tabs
Remove this line
<tab idMso="TabAddIns" visible="false"/>




<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

<!-- **************************************************************************-->
<!-- **********Set visible to false for all tabs on the ribbon*****************-->
<!-- **************************************************************************-->

<ribbon>
<tabs>

<tab idMso="TabHome" visible="false"/>
<tab idMso="TabInsert" visible="false"/>
<tab idMso="TabPageLayoutExcel" visible="false"/>
<tab idMso="TabFormulas" visible="false"/>
<tab idMso="TabData" visible="false"/>
<tab idMso="TabReview" visible="false"/>
<tab idMso="TabView" visible="false"/>
<tab idMso="TabDeveloper" visible="false"/>
<tab idMso="TabAddIns" visible="false"/>

</tabs>
</ribbon>

</customUI>
 
J

Jim Rech

This will hide all tabs

Not quite all, Ron, I don't believe. It doesn't hide the contextual tabs.
Nor does StartFromStratch interestingly.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon>
<contextualTabs>
<tabSet idMso="TabSetSmartArtTools" visible="false" />
<tabSet idMso="TabSetChartTools" visible="false" />
<tabSet idMso="TabSetDrawingTools" visible="false" />
<tabSet idMso="TabSetPictureTools" visible="false" />
<tabSet idMso="TabSetPivotTableTools" visible="false" />
<tabSet idMso="TabSetHeaderAndFooterTools" visible="false" />
<tabSet idMso="TabSetTableToolsExcel" visible="false" />
<tabSet idMso="TabSetPivotChartTools" visible="false" />
<tabSet idMso="TabSetInkTools" visible="false" />
</contextualTabs>
</ribbon>
</customUI>

--
Jim
| Hi Jwh
|
| This will hide all tabs
| Remove this line
| <tab idMso="TabAddIns" visible="false"/>
|
|
|
|
| <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
|
| <!--
**************************************************************************-->
| <!-- **********Set visible to false for all tabs on the
ribbon*****************-->
| <!--
**************************************************************************-->
|
| <ribbon>
| <tabs>
|
| <tab idMso="TabHome" visible="false"/>
| <tab idMso="TabInsert" visible="false"/>
| <tab idMso="TabPageLayoutExcel" visible="false"/>
| <tab idMso="TabFormulas" visible="false"/>
| <tab idMso="TabData" visible="false"/>
| <tab idMso="TabReview" visible="false"/>
| <tab idMso="TabView" visible="false"/>
| <tab idMso="TabDeveloper" visible="false"/>
| <tab idMso="TabAddIns" visible="false"/>
|
| </tabs>
| </ribbon>
|
| </customUI>
| Regards Ron de Bruin
| http://www.rondebruin.nl/tips.htm
 
R

Ron de Bruin

Hi Jim

Thanks for your reply

I will add a example for this on my ribbon page this weekend in
the downlod with examples for the Custom UI editor.

Will try to test a few things this evening but I am sure you are correct
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top