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:
Here is what we want:
Sub hide_menu()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",False)"
End Sub
Follow the same steps above and put the following piece of code below the one in the previous steps.
Sub show_menu()
Application.ExecuteExcel4Macro "show.toolbar(""Ribbon"",True)"
End Sub
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.