Selective Ribbon miminise

  • Thread starter Thread starter Gordon
  • Start date Start date
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...
 
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>
 
You must log in or register to reply here.

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

Similar Threads

Selective Ribbon load in 2007 3
Ribbon and toolbar, program control 2
Expand/collapse toolbar ribbon 6
Disabling Ribbon in '07 4
Adding Items at runtime in the Ribbon ComboBox 3
Hide Ribbon In XLS Workbook When Using Excel 2007 12
Cell Toolbar Dilemma xl2013 13
Excel ribbon problem with Quick access toolbar 7

Back
Top