<!-- This is example : Dictator(2) With_Custom_Tab.xlsm -->
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<!-- **************************************************************************-->
<!-- ****Disable 'Exit Excel' and 'Excel Options' on the Office Button menu****-->
<!-- **************************************************************************-->
<commands>
<command idMso="ApplicationOptionsDialog" enabled="false"/>
<command idMso="FileExit" enabled="false"/>
</commands>
<!-- *******************************************************************-->
<!-- *****Set startFromScratch to true to hide the Ribbon and QAT*******-->
<!-- ********Hide New, Open and Save on the Office Button menu**********-->
<!-- **************Hide Contextual tabs on the Ribbon*******************-->
<!-- *******************************************************************-->
<!-- 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 also hides most of the commands on the Office Button menu, but for -->
<!-- some reason, it does not hide the 'New', 'Open' and 'Save' commands. -->
<!-- Also 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: -->
<officeMenu>
<button idMso="FileNew" visible="false"/>
<button idMso="FileOpen" visible="false"/>
<button idMso="FileSave" visible="false" />
</officeMenu>
<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>
<!-- Add Custom tab to the Ribbon with your own buttons-->
<!-- The example add three groups to the new tab named 'My Tab' -->
<!-- On the last tab there is a menu with five options-->
<tabs>
<tab id="MyCustomTab" label="My Tab" >
<group id="customGroup2" label="Reminders">
<button id="customButton7" label="Send Emails" size="large" onAction="Macro7" imageMso="ReviewPreviousComment" />
</group>
</tab>
</tabs>
</ribbon>
</customUI>
No comments:
Post a Comment