excel 2016 quick access toolbar close command

The Quick Access Toolbar (QAT) in Microsoft Office is a handy place to store your favorite commands and features. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Learn how to tweak the Quick Access Toolbar by adding and removing commands and then export your changes to another computer with Microsoft Office. Buttons have been created in the workbook to make it easier to see the result of these macros.How to customize the Quick Access Toolbar in Microsoft Office Make sure to download the accompanying workbook so you can see the macros in action. You can minimize the ribbon menu but you cannot completely hide it without using VBA Macro code. There is no other way to completely remove the Ribbon menu in Excel.

Now, go back to the Excel window and you can hit Alt + F8 to select and run the macro to show the menu:.

Add the following code below the other code:Īpplication.ExecuteExcel4Macro 'show.toolbar(''Ribbon'',True)'.

A window will open and you select the hide_menu macro and hit the Run button.įollow the same steps above and put the following piece of code below the one in the previous steps. Then hit Alt + F8 to be able to run the macro.

Hit Alt + F11 to go back to the Excel window.

Copy and Paste this into the white area:Īpplication.ExecuteExcel4Macro 'show.toolbar(''Ribbon'',False)'.

As well, this method will hide the quick access toolbar and the Office or File buttons (depending on your version of Excel). This will allow you to have a streamlined Excel interface and to prevent users from accessing any menu in Excel.

I'll show you how to completely remove the entire Ribbon Menu from Excel. Updated Version: Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More

Excel 2016 quick access toolbar close command