• Lock down Excel’s custom quick access toolbar

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Lock down Excel’s custom quick access toolbar

    Author
    Topic
    #491435

    Hello…

    Is there a way to lock Excel’s custom quick access toolbar so a user is not allowed to change it? I know it defeats the purpose of the tool, but it sure makes it difficult to help people on their own computer when everyone’s toolbar is different.

    Thanks so much!
    Lana

    Viewing 0 reply threads
    Author
    Replies
    • #1417052

      LJM,

      These lines of code will disable/enable the QAT by hidng it. Unfortunately, it will hide the entire ribbon as well. If you do not mind that then here you go!

      HTH,
      Maud

      Code:
      Application.ExecuteExcel4Macro “SHOW.TOOLBAR(“”Ribbon””,True)”
      
      Application.ExecuteExcel4Macro “SHOW.TOOLBAR(“”Ribbon””,False)”
      
    Viewing 0 reply threads
    Reply To: Lock down Excel’s custom quick access toolbar

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: