How to show or hide the QAT (Quick Access Toolbar) in vba ?

David Bourcier 0

Hello,

Is it possible to show or hide the QAT Quick Access Toolbar in vba?

With the code Application.CommandBars.ExecuteMso ("MinimizeRibbon") I can hide the whole Ribbon but not only the QAT. Is there an idMso for the QAT?

Best Regards,

David

Charles Kenyon 2,671 Reputation points

2023-03-12T14:05:20.2966667+00:00
The UI command to hide the QAT is quite recent. I know of nothing that can do this, and I would hope that I would.

I've done a fair amount of work with the QAT including XML mods.

https://addbalance.com/word/QATmodification.htm#PageStart

However, I have never done modification using vba. You might check Greg Maxey's work. https://gregmaxey.com/word_tip_pages/customize_ribbon_main.html

Some aspects of Word never make it into the object model (vba).

The book [RibbonX: Optimizing the Office Ribbon] remains very useful and may cover this. Here is a[ link for free download of pdf], I believe.

[http://www.amazon.com/exec/obidos/ISBN=0470191112/balancecheckbookA/]

https://web.archive.org/web/20180417112605/http://site.thehousewaresstore.com/oodle/AccessBooks/Wiley.RibbonX.Customizing.the.Office.2007.Ribbon.Jan.2008.pdfizing.the.Office.2007.Ribbon.Jan.2008.pdf
David Bourcier 0 Reputation points

2023-03-12T19:34:50.12+00:00

Thank you very much Charles, that's very nice of you!

I'll take a look at it all.

Have a nice evening,

David