What VBA Code to Hide Excel Quick Access Toolbar

0 votes

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:

enter image description here

Jan 23, 2023 in Others by Kithuzzz
• 38,020 points
1,118 views

1 answer to this question.

0 votes

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
answered Jan 23, 2023 by narikkadan
• 63,680 points

Related Questions In Others

0 votes
1 answer

What would I have to add to this VBA Code to keep Undo Button working after it runs?

VBA eliminates Excel's undo function. Though it ...READ MORE

answered Dec 16, 2022 in Others by narikkadan
• 63,680 points
489 views
0 votes
1 answer

What VBA code would I use to concatenate cell A2 & B2 in cell C2 and then have it Autofill down the column?

Solution Find the last row. Write a formula to ...READ MORE

answered Feb 14, 2023 in Others by Kithuzzz
• 38,020 points
972 views
0 votes
1 answer

Language independent way to get "My Documents" folder in VBA Excel 2003

 Hello :)  This code may help you in your ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
791 views
0 votes
1 answer

How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

answered Feb 17, 2022 in Others by gaurav
• 23,260 points
4,031 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,165 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,606 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9, 2022 in Others by gaurav
• 23,260 points
868 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,021 views
0 votes
1 answer

How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,680 points
3,717 views
0 votes
1 answer

How to programmatically code an 'undo' function in Excel-Vba?

Add the command button to the worksheet ...READ MORE

answered Nov 25, 2022 in Others by narikkadan
• 63,680 points
1,018 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP