Thursday, September 8, 2016

XML Code for Xml Menu Hide - UI14


<!-- This is example :  Dictator(2) With_Custom_Tab.xlsm  -->

<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" />
<tabSet idMso="TabSetSparkline" visible="false" />
<tabSet idMso="TabSetTimeSlicerTools" visible="false" />
<tabSet idMso="TabSetSlicerTools" visible="false" />
<tabSet idMso="TabSetEquationTools" 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>

<!--hide all buttons and tabs in Backstage (File)-->
    <backstage>
        <button idMso="FileSave" visible="false"/>
        <button idMso="FileSaveAs" visible="false"/>
        <button idMso="FileOpen" visible="false"/>
        <button idMso="FileClose" visible="false"/>
        <button idMso="ApplicationOptionsDialog" visible="false"/>
        <button idMso="FileExit" visible="false"/>
        <tab idMso="TabInfo" visible="false"/>
        <tab idMso="TabRecent" visible="false"/>
        <tab idMso="TabNew" visible="false"/>
        <tab idMso="TabPrint" visible="false"/>
        <tab idMso="TabShare" visible="false"/>
        <tab idMso="TabHelp" visible="false"/>
        <tab idMso="TabPublish" visible="false"/>
        <tab idMso="TabSave" visible="false"/>
        <tab idMso="TabOfficeStart" visible="false"/>
    </backstage>
</customUI>


No comments:

Post a Comment