I would like to remove all menus from the ribbon except for the "Add on" menu. I dont want the user to have access to do anything besides what's under the add on menu. Can anyone tell me how to achieve that task?
Printable View
I would like to remove all menus from the ribbon except for the "Add on" menu. I dont want the user to have access to do anything besides what's under the add on menu. Can anyone tell me how to achieve that task?
You can add/edit the CustomUI.xml and make
and then put things backCode:<ribbon startFromScratch="true">
Here's a more complete example
Code:<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<!-- Set startFromScratch to true to hide the Ribbon and QAT-->
<ribbon startFromScratch="true">
<!-- startFromScratch="true" hides all of the Ribbon tabs and it hide the QAT. -->
<!-- It not hides the Contextual tabs on the ribbon, for example the -->
<!-- Format tab that you see when you select a picture on your worksheet. -->
<!-- So if you want to hide them you must use the RibbonX below: -->
<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>
<!-- You can add xml here to create your own custom tab on the ribbon-->
</ribbon>
</customUI>
Thanks Paul.
But does the above XML code go directly into a module? For example, do I create a function/sub and put the XML code in the function?
No, you need to use a CustomUI editor to add the XML to the XLSM but outside of Excel
https://www.rondebruin.nl/win/s2/win001.htm
I use the older version that RdB refers to, but the newer one sounds nicer
There is a Ribbon UI forum here if you want me to more this to there
http://www.vbaexpress.com/forum/foru...2007-Ribbon-UI