We are in the process of updating the site, so some pages still have the older design.

Completely Hide the Quick Access Toolbar in Excel

Download Project Files
Author:

I'll show you how to completely remove the entire Quick Access Toolbar from Excel.

This will allow you to have a streamlined Excel interface and to prevent users from accessing menu shortcuts.  This method will also remove the Ribbon Menu and either the File or Office buttons from the top of the window, depending on your version of Excel.

Here is the normal Excel interface:

Here is what we want:

Steps to Remove the Quick Access Toolbar Menu:

  1. Hit Alt + F11 on the keyboard.  This brings up the VBA window:
  2. Go to Insert > Module

  3. Copy and Paste this into the white area:
    1. Sub hide_menu()

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

      End Sub

  4. Hit Alt + F11 to go back to the Excel window.  Then hit Alt + F8 to be able to run the macro.  A window will open and you select the hide_menu macro and hit the Runbutton.
  5. Now the menu is gone:

How to Show the Hidden Quick Access Toolbar Menu

Follow the same steps above and put the following piece of code below the one in the previous steps.

  1. Hit Alt ­+ F11.
  2. Add the following code below the other code:
    1. Sub show_menu()

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

      End Sub

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

 

There is no other way to completely remove the Quick Access Toolbar.  You can remove buttons from it or move it around a little, but you cannot completely hide it without using VBA Macro code.

Make sure to download the accompanying workbook so you can see the macros in action.  Buttons have been created in the workbook to make it easier to see the result of these macros.  This means that you will not have to hit Alt+F8 in order to use the macros.

Download the Project Files

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Completely Hide the Ribbon Menu in Excel
Tutorial: Updated Version: Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Sta...
Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More
Tutorial: How to hide every single part of the Excel interface with the click of a button! This all...
Hide the Excel Interface and Show Only Data
Tutorial: I'm going to show you how to remove almost every interface from Excel and streamline the...
Use a Form to Enter Data into a Table in Excel
Tutorial: You can enter data into a table in Excel using a form; here I'll show you how to do that....
Format Cells in The General (default) Format in Excel Number Formatting
Macro: This free Excel macro formats a selected cell or range of cells to the General number form...
Create a 12 Month Calendar With The Current Day Highlighted in Excel
Macro: Create a 12 month formatted calendar on a new tab in Excel with the current day highlighte...
Tutorial Details
Downloadable Files: Project File

Download Project File

Follow along with the tutorial by downloading the files used in it. (Completely Free)

Phone number is optional - we use it to send course discounts and weekly updates via SMS.

SMS Terms ▾
By submitting this form, you agree to receive recurring automated marketing text messages from TeachExcel at the mobile number provided. Consent is not a condition of any purchase. Msg frequency varies. Msg & data rates may apply. Reply HELP for help or STOP to cancel at any time.

View our Privacy Policy | Terms of Use
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course