Tutorial Details
Downloadable Files: Excel File
Introduction to Programming Macros in Excel
First Steps
Getting and Inputting Data
Adding Logic to Macros
UDF- User Defined Functions
Speeding Up Macros

Completely Hide the Ribbon Menu in Excel

Add to Favorites

I'll show you how to completely remove the entire Ribbon Menu from Excel.

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

Here is the normal Excel interface:


Here is what we want:


Steps to Remove the Ribbon Menu:

  1. Hit Alt + F11 on the keyboard.  This brings up the VBA window:
    1. 3569d8f1b2ae1509c2347ff53c289f8d.png
  2. Go to Insert > Module
    1. 8d20360f9bed929e9403e68395a9b1d0.jpg
    2. 5add40ded058f451e540364ad8df6976.png
  3. Copy and Paste this into the white area:

      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 Run button.
    1. 82a2227dc81a88298bec5a01f7f5b544.png
  5. Now the menu is gone:
    1. abbe0d7778ccd0a440746fa85011f39b.png

How to Show the Hidden Ribbon 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:

      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:
    1. 7d6ae34c57a831d8b787d32b1cce7f45.png
  4. Now the menu is back:
    1. 58c7ae547237da781c115aad22d430b1.png

There is no other way to completely remove the Ribbon menu in Excel.  You can minimize the ribbon menu 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.


Question? Ask it in our Excel Forum

Downloadable Files: Excel File