locked
Show Quick Access Toolbar ONLY RRS feed

  • Question

  • Hello,

    Excel 2010-2013. I'm trying to show the Quick Access Toolbar only. Through VBA I can hide all toolbars and menus including the QAT. Is there a way to show the QAT only? Or a working example of how to show only a customized menu with one button to call the Insert Image command?

    Regards
    Peter

    Monday, August 5, 2013 9:14 AM

Answers

  • Yes that is correct, there is also no startfromscratch option for backstage like you have for the Ribbon.

    I have some info and example workbooks here for Backstage

    http://www.rondebruin.nl/win/s2/win005.htm

    Why not disable the ribbon and QAT and add a popup menu to the workbook


    Regards Ron de Bruin http://www.rondebruin.nl/tips.htm

    • Marked as answer by _peak_ Wednesday, August 7, 2013 7:36 AM
    Tuesday, August 6, 2013 6:55 PM
  • Thanks again Ron,

    I have acheived almost what I wanted. I can now hide the ribbon but the File tab (which is empty). I have the QAT visible with the Insert Picture command. It's done via this XML:

    <!--
    Hide everything on the ribbon (but the File tab called 'backstage', which will be empty).
    Show the Quick Access Toolbar (QAT) with the Insert Picture command.
    Tested on Excel 2010. No VBA code needed.
    
    Insert below XML with the Custom UI Editor into an Office document:
    http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx
    Tutorial: http://www.rondebruin.nl/win/s2/win001.htm
    -->
    <customUI  xmlns="http://schemas.microsoft.com/office/2009/07/customui">
        <ribbon startFromScratch="true">
          <qat>
            <sharedControls>
              <control idMso="PictureInsertFromFile" visible="true"/>
            </sharedControls>
          </qat>
          <tabs >
            <tab idMso="TabHome" visible="false"/>
            <tab idMso="TabInsert" visible="false"/>
            <tab idMso="TabPageLayoutExcel" visible="false"/>
            <tab idMso="TabFormulas" visible="false"/>
            <tab idMso="TabData" visible="false"/>
            <tab idMso="TabReview" visible="false"/>
            <tab idMso="TabView" visible="false"/>
            <tab idMso="TabAddIns" visible="false"/>
            <tab idMso="TabPrintPreview" visible="false"/>
          </tabs >
        </ribbon >
        <backstage>
          <button idMso="FileSave" visible="false"/>
          <button idMso="FileSaveAs" visible="false"/>
          <button idMso="FileClose" visible="false"/>
          <button idMso="FileOpen" visible="false"/>
          <button idMso="FileExit" visible="false"/>
          <button idMso="ApplicationOptionsDialog" visible="false"/>
          <tab idMso="TabInfo" visible="false"/>
          <tab idMso="TabPrint" visible="false"/>
          <tab idMso="TabShare" visible="false"/>
          <tab idMso="TabHelp" visible="false"/>
          <tab idMso="TabRecent" visible="false"/>
          <tab idMso="TabNew" visible="false"/>
        </backstage>
    </customUI>
    

    Regards
    Peter
    • Marked as answer by _peak_ Wednesday, August 7, 2013 7:35 AM
    Wednesday, August 7, 2013 7:33 AM

All replies

  • Why not create your own custom Ribbon and hide the ribbon and QAT, see

    http://www.rondebruin.nl/win/s2/win001.htm

    There are example files


    Regards Ron de Bruin http://www.rondebruin.nl/tips.htm

    Monday, August 5, 2013 6:54 PM
  • Ron,

    Thanks for your reply. However, I’ve been down that route. I now have everything hidden but the backstage (File) tab. I can disable items within the tab but not the tab itself. Google only tells me how to customize items in it, not to hide it altogether.

    Regards
    Peter

    Tuesday, August 6, 2013 5:24 AM
  • Yes that is correct, there is also no startfromscratch option for backstage like you have for the Ribbon.

    I have some info and example workbooks here for Backstage

    http://www.rondebruin.nl/win/s2/win005.htm

    Why not disable the ribbon and QAT and add a popup menu to the workbook


    Regards Ron de Bruin http://www.rondebruin.nl/tips.htm

    • Marked as answer by _peak_ Wednesday, August 7, 2013 7:36 AM
    Tuesday, August 6, 2013 6:55 PM
  • Thanks again Ron,

    I have acheived almost what I wanted. I can now hide the ribbon but the File tab (which is empty). I have the QAT visible with the Insert Picture command. It's done via this XML:

    <!--
    Hide everything on the ribbon (but the File tab called 'backstage', which will be empty).
    Show the Quick Access Toolbar (QAT) with the Insert Picture command.
    Tested on Excel 2010. No VBA code needed.
    
    Insert below XML with the Custom UI Editor into an Office document:
    http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2009/08/06/7293.aspx
    Tutorial: http://www.rondebruin.nl/win/s2/win001.htm
    -->
    <customUI  xmlns="http://schemas.microsoft.com/office/2009/07/customui">
        <ribbon startFromScratch="true">
          <qat>
            <sharedControls>
              <control idMso="PictureInsertFromFile" visible="true"/>
            </sharedControls>
          </qat>
          <tabs >
            <tab idMso="TabHome" visible="false"/>
            <tab idMso="TabInsert" visible="false"/>
            <tab idMso="TabPageLayoutExcel" visible="false"/>
            <tab idMso="TabFormulas" visible="false"/>
            <tab idMso="TabData" visible="false"/>
            <tab idMso="TabReview" visible="false"/>
            <tab idMso="TabView" visible="false"/>
            <tab idMso="TabAddIns" visible="false"/>
            <tab idMso="TabPrintPreview" visible="false"/>
          </tabs >
        </ribbon >
        <backstage>
          <button idMso="FileSave" visible="false"/>
          <button idMso="FileSaveAs" visible="false"/>
          <button idMso="FileClose" visible="false"/>
          <button idMso="FileOpen" visible="false"/>
          <button idMso="FileExit" visible="false"/>
          <button idMso="ApplicationOptionsDialog" visible="false"/>
          <tab idMso="TabInfo" visible="false"/>
          <tab idMso="TabPrint" visible="false"/>
          <tab idMso="TabShare" visible="false"/>
          <tab idMso="TabHelp" visible="false"/>
          <tab idMso="TabRecent" visible="false"/>
          <tab idMso="TabNew" visible="false"/>
        </backstage>
    </customUI>
    

    Regards
    Peter
    • Marked as answer by _peak_ Wednesday, August 7, 2013 7:35 AM
    Wednesday, August 7, 2013 7:33 AM
  • Hello Ron,

    Thanks for the article. I am able to hide all the tabs and buttons in backstage. I have requirement, where user should not be allowed to save the file when opened from sharepoint. By customizing the ribbon, I am able to remove Save, Save As and QAT. But now when user edits the workbook then while closing excel will flash an pop-up "Do you want to save the changes to ....xlsx"? So, user can chose save and save the file.

    Is there any way to disable this pop-up by customUI? Doing it by macro is a way but its not full proof. What if user did some changes and tries to save the file before enabling macors.?

    Requesting your help on this.

    Thursday, January 23, 2014 6:20 AM
  • Hi Ron

    Firstly, thank you for the help that your site provides, it has helped me no end.

    When you disable the ribbon tabs in your sample on your site you can show/hide the ribbon tabs.

    Can this be done with the QAT as well...

    maybe creating this

    <qat>
            <sharedControls> 
                  <control idMso="FileNewDefault" /> 
                  <control idMso="FileOpen" /> 
                  <control idMso="FileSave" /> 
                  <control idMso="FileSendAsAttachment" /> 
                  <control idMso="FilePrintQuick" />
    <control idMso="PrintPreviewAndPrint" /> 
                  <control idMso="Spelling" /> 
                  <control idMso="Undo" /> 
                  <control idMso="Redo" /> 
                  <control idMso="SortAscendingExcel" /> 
                  <control idMso="SortDescendingExcel" /> 
                  <control idMso="FileOpenRecentFile" /> 
          </sharedControls> 
    </qat>

    This doesn't give you the option to show/hide the controls by using the dropdown to the right of the QAT. All options are disabled.

    This also seems to put it in a different order to what is listed above. Why is this?

    Is it possible to alter the QAT bar and enable the options

    Thanks 

    Kev

    Thursday, June 19, 2014 12:50 AM