How To: Automatically Hide the Ribbon Menu System in Excel

Automatically Hide the Ribbon Menu System in Excel

Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl+F1 which partially hides the ribbon, Alt+F11, which opens the Visual Basic screen, and Alt+F8, which opens the macros list. First, hit Alt+F11 to open the Visual Basic screen. Then double-click "This Workbook" on the left-side panel and a window should open. Click the drop-down menu that says "(General)" and click "Workbook." The macro will be written between the lines "Private Sub Workbook_Open()" and "End Sub." Type Application.ExecuteExcel4macro "show.toolbar(""Ribbon"",False)" and then close the screen and save the workbook as a macro-enabled workbook. Close your workbook and reopen it to see if the Ribbon has disappeared. The benefit of this is to create files that can not be edited by others, only read. The only way to get the Ribbon back is to delete the macro and save the workbook again.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

1 Comment

Share Your Thoughts

  • Hot
  • Latest