none
Ribbon XML, how to enable QAT "More Commands" RRS feed

  • Question

  • Hi,

    I have created own Ribbon from scratch, i need to enable "More Commands..." function from QAT. But i can't find how to do this, can anyone give me a tip :)?

    Adding screen shot: http://prnt.sc/agb5oa

    <?xml version="1.0" encoding="UTF-8"?>
    <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="Ribbon_Load" loadImage ="LoadImage">
      <commands>
        <!-- Disable Excel Options on the Office button menu--><!--
        <command idMso="ApplicationOptionsDialog" enabled="false"/>-->
        <!-- Disable Exit Excel on the Office button menu-->
        <command idMso="FileExit" enabled="false"/>
        <command idMso="FileNew" enabled="false"/>
        <command idMso="FileSaveAs" enabled="false"/>
        <!--<command idMso="WindowClose" enabled="false"/>-->
      </commands>
      <ribbon startFromScratch ="true">
        <qat>
          <sharedControls>
            <control idMso="FileSave" screentip="Išsaugoti dokumento pakeitimus (Ctrl+S)"/>
            <control idMso="Undo" screentip="Anuliuoti paskutinį veiksmą (Ctrl+Z)"/>
            <control idMso="Redo" screentip="Atstatyti į paskutinį veiksmą (Ctrl+Y)"/>
            <control idMso="FilePrintQuick" screentip="Greitas spausdinimas"/>
            <control idMso="FilePrintPreview" screentip="Spausdinimo peržiūra" />
            <button id="Ikainuk" getEnabled="RodytiSamMenuIk" getVisible="RodytiNewIk" onAction="newIk_Click" image ="ik48.png" .. />

    .....

         </sharedControls>
        </qat>
        <officeMenu>
          <button idMso="FileNew" visible="false"/>
          <button idMso="FileOpen" visible="true"/>
          <button idMso="FileSave" visible="true"/>
          <!--<button idMso="FileSaveAs" visible="false" />
          <button idMso="WindowClose" visible="false" />
          <button idMso="FileNew" visible="false" />-->
          <button idMso="FileSaveAsPdfOrXps" visible="true" label="Išsaugoti į PDF" />
          <splitButton idMso="FilePrintMenu" visible="true" />      
        </officeMenu>
    ....


    http://prntscr.com/agb5oa
    Thursday, March 17, 2016 9:26 AM

Answers

  • >>>Also if i try to open manually "File"-> "Excel options" -> "Quick Access Toolbar" i get empty list here is pic:<<<

    According to your description, I have tried to use VBA code to resolve this issue, but I can't find and solution to overcome it. So I suggest that submit any feedback to Excel User Voice:

    http://excel.uservoice.com/

    Thanks for your understanding.


    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13020849-vsto-add-in-qat-enable-more-commands
    • Marked as answer by Julius Bank Friday, March 18, 2016 7:45 AM
    Friday, March 18, 2016 7:45 AM

All replies

  • Ty for finding whole list, but its not that idMso i wanted:

    As you see: http://prntscr.com/agdrw6

      <ribbon startFromScratch ="true">
        <qat>
          <sharedControls>
            <control idMso="FileSave" screentip="Išsaugoti dokumento pakeitimus (Ctrl+S)"/>
            <control idMso="Undo" screentip="Anuliuoti paskutinį veiksmą (Ctrl+Z)"/>
            <control idMso="Redo" screentip="Atstatyti į paskutinį veiksmą (Ctrl+Y)"/>
            <control idMso="FilePrintQuick" screentip="Greitas spausdinimas"/>
            <control idMso="FilePrintPreview" screentip="Spausdinimo peržiūra" />
            <control idMso="MoreControlsDialog" screentip="More Commands.."/>

    .....

    Also if i try to open manually "File"-> "Excel options" -> "Quick Access Toolbar" i get empty list here is pic:

    http://prnt.sc/ageddi


    Thursday, March 17, 2016 1:53 PM
  • >>>Also if i try to open manually "File"-> "Excel options" -> "Quick Access Toolbar" i get empty list here is pic:<<<

    According to your description, I have tried to use VBA code to resolve this issue, but I can't find and solution to overcome it. So I suggest that submit any feedback to Excel User Voice:

    http://excel.uservoice.com/

    Thanks for your understanding.


    Friday, March 18, 2016 5:17 AM
  • >>>Also if i try to open manually "File"-> "Excel options" -> "Quick Access Toolbar" i get empty list here is pic:<<<

    According to your description, I have tried to use VBA code to resolve this issue, but I can't find and solution to overcome it. So I suggest that submit any feedback to Excel User Voice:

    http://excel.uservoice.com/

    Thanks for your understanding.


    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/13020849-vsto-add-in-qat-enable-more-commands
    • Marked as answer by Julius Bank Friday, March 18, 2016 7:45 AM
    Friday, March 18, 2016 7:45 AM