Selective Ribbon miminise

G

Gordon

Hi...

Is it possible to for a macro to disable the ribbon but keep the quick
access toolbar off which I want to use my own toolbar?

Cheers

Gordon...
 
R

Ron de Bruin

Hi Gordon

If you Set startFromScratch to true it also hide the QAT so maybe this is a option for you


You can use the RibbonX below in the file
See this page how to add it to your file
http://www.rondebruin.nl/ribbon.htm




<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>
 
Top