Thursday, September 8, 2016

XML Code for Xml Menu Hide - UI


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