Office2007 Custom UI Editor and our Addins-How to show our Addin t

  • Thread starter Thread starter MB34
  • Start date Start date
M

MB34

Need to know how to show our add-in tab when using the Office2007 Custom UI
Editor.

We know how to make the built-in tabs visible but not how to show our
add-in's tab.
 
Your addin will be on the addins tab.

Other than that, you need to build a custom group or tab.
 
Need to know how to show our add-in tab when using the Office2007 Custom
Your addin will be on the addins tab.

Other than that, you need to build a custom group or tab.
Click to expand...

I beg to differ. Our addin has it's OWN tab in the ribbon.
 
I beg to differ. Our addin has it's OWN tab in the ribbon.
What do you want to know or want to do ?
I not understand what you want on this moment

Do you create a custum tab with RibbonX for you add-in ???
Click to expand...

No, we use Add-In Express to build our add-in and it allows us to create our
own ribbon. I can't even see it in OutlookSpy, CommandBars collection.

We want to show our Ribbon and remove all others but the data ribbon.
 
I not know how this program works but try to open the add-in with the Custom UI Editor

For information how to do this see
http://www.rondebruin.nl/ribbon.htm

On this page I have examples to only show your custom tab
See point 2 for example files
Look at the RibbonX and add it to your add-in

But for a add-in I not think it is good idea to hide the other ribbon tabs

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
 
I not know how this program works but try to open the add-in with the
Custom UI Editor
For information how to do this see
http://www.rondebruin.nl/ribbon.htm

On this page I have examples to only show your custom tab
See point 2 for example files
Look at the RibbonX and add it to your add-in

But for a add-in I not think it is good idea to hide the other ribbon tabs
Click to expand...

We do not intend to do this *from* the add-in but in an Excel workbook.If
the user has the add=-in installed, we want it's ribbon to show also.

This is for a kind of "dashboard" app using Excel.
 
If you want to open a workbook and only show the custom Add-in tab and the Data tab
You must add ribbonX to the workbook to hide the built-in tabs (not the Data tab)

Your RibbonX looks like this then

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


<!-- **************************************************************************-->
<!-- ****Disable 'Exit Excel' and 'Excel Options' on the Office Button menu****-->
<!-- ****Note: See that the RibbonX below is before the <ribbon> start line****-->
<!-- **************************************************************************-->

<commands>
<command idMso="ApplicationOptionsDialog" enabled="false"/>
<command idMso="FileExit" enabled="false"/>
</commands>



<ribbon>

<!-- **************************************************************************-->
<!-- *****Set visible to false for all controls on the Office Button menu******-->
<!-- **************************************************************************-->

<officeMenu>
<button idMso="FileNew" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileSave" visible="false" />
<splitButton idMso="FileSaveAsMenu" visible="false"/>
<splitButton idMso="FilePrintMenu" visible="false"/>
<menu idMso="FilePrepareMenu" visible="false" />
<menu idMso="FileSendMenu" visible="false"/>
<menu idMso="MenuPublish" visible="false"/>
<button idMso="FileClose" visible="false" />
</officeMenu>


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

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

<!-- **************************************************************************-->
<!-- ********Set visible to false for all Contextual tabs on the 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>


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
 
If you want to open a workbook and only show the custom Add-in tab and the Data tab
You must add ribbonX to the workbook to hide the built-in tabs (not the Data tab)

Your RibbonX looks like this then
Click to expand...

Yes, Ron, we know that but I cannot find our Ribbon name in Outlook Spy (The
ribbon works in both Excel and Outlook) to be able to set it's visible to
True because it is not visible when we only have the data tab showing.
The add-in is for a document management system and we are also adding these
dashboard apps for Excel.
 
If you want you can send me the add-in private and I will take a look when
I have time

Actually, it was the startfromscratch option that was keeping the Add-In's
ribbon from showing.

Your RibbonX did the job, although I had to add TabData. ;-)

Thanks for the help.
 
Back
Top