Completely Hide the Ribbon Menu in Excel

Add to Favorites
Author: | Edits: don

Updated Version: Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More

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:

87e63273cd94c965bcd6909926341ed6.png

Here is what we want:

5c8352e03646b344c882fe7ea9bdfa53.png

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:
    1.  

      Sub hide_menu()

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

      End Sub

      e58ef9a41e77b83dd514d37f1290fa74.png

  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:
    1.  

      Sub show_menu()

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

      End Sub

      fb41b12937eb00af5ace841777ef54d4.png

  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.

db1567808b6d267722012eb348d608aa.png


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.

Similar Content on TeachExcel
Minimize or Maximize the Ribbon Menu in Excel
Tutorial: This is a simple way to get more space in Excel, reduce clutter, and streamline the inte...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
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...
Completely Hide the Quick Access Toolbar in Excel
Tutorial: I'll show you how to completely remove the entire Quick Access Toolbar from Excel. Th...
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...
Custom Data Views Controlled by a Drop Down Menu in Excel
Tutorial: This trick allows you to easily perform a nice visual analysis of data in Excel without m...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Minimize or Maximize the Ribbon Menu in Excel
Tutorial: This is a simple way to get more space in Excel, reduce clutter, and streamline the inte...
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
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...
Excel Forum