What VBA Code to Hide Excel Quick Access Toolbar

Question

I'm looking for code that solely modifies the Excel Quick Access Toolbar (makes it Visible and Hides it). The code I have conceals the toolbar and the Ribbon Structure as a whole.

'Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"", False)" is my current code (Hides Everything).

The manual way in the options menu makes it simple to hide, but Excel won't record a macro to do so:

Answer 1

Use this:

Sub HideQuickAccessTB()
    Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
End Sub

To show it, use the next version:

Sub ShowQuickAccessTB()
    Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)"
End Sub