VBA Code to Hide Quick Access Toolbar

[MikeG]

I am hoping someone can give me the VBA code to hide the QAT.

In my research I have seen code to hide the main menu/ribbon, and which also hides the QAT:

Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",false)"

However, I want to keep the main menu/ribbon and only hide the QAT,.

Thanks,

Mike

 

[Logit]

Which part of the top most tool/menu bar are you referring to ? By definition, the QAT is the menu bar :

Completely Hide the Quick Access Toolbar in Excel - TeachExcel.com

 

[MikeG]

Thanks Logit.

The naming for the screen components seems to vary a bit by source, but I am seeing two main components. There is what some call the "Tab Bar" that has the standard "File" "Home", etc. choices and this bar is directly linked to the full ribbon, which can be shown or hidden using Ctrl F1. The second is the QAT, which is the bar where you can define your own buttons.

I did see the article you linked to, and that shows how to hide the Tab Bar and the Ribbon, and I guess as a side-effect, that also hides the QAT.

As the top of the article explains:

"I'll show you how to completely remove the entire Quick Access Toolbar from Excel... This method will also remove the Ribbon Menu"

Maybe there is no way to isolate the QAT.

Thanks again.

 

[Logit]

You then are referring to the small DOWN ARROW that allows you to Customize the QAT ?

 

[MikeG]

I'm referring to the whole bar, of which the Down Arrow is a part, and which has the disk symbol and the undo and redo symbols. I am calling this whole QAT bar. I want to hide that, but keep displaying the main menu tab bar and ribbon as displayed.

Thanks

 

[Logit]

I located a resource that speaks of editing the XML file :

How to disable the Customize Quick Access Toolbar "BUTTON"

Google 'editing xml file' for specific instructions.


An alternative would be to hide everything, show the workbook Full Screen, the create your own menu bar on a USER FORM.

 

[johnnyL]

This sounds like something @Jaafar Tribak could possibly look into.