VBA Code to hide Ribbon Bar

**pmgibbs79** · 11-29-2016, 11:32 PM

Hi everyone, I have produced a excel order for one of our clients but I hate that they can see the Ribbon bar would prefer to see it shown as a full screen no ribbon bar unless I need to work on it, this VBA code needs to work every time the order form is opened. I have tried a lot of code but had no luck with it sticking every time it is opened. can anyone help with a simple VBA code, or have a better solution for to get the result I want.

**Logit** · 11-30-2016, 12:13 AM

Using this syntax in ThisWorkBook:

Private Sub Workbook_Open()
    'These commands disable the menu bar.
   
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    'These commands re-enable the menu bar so other workbooks
    'won't be affected.
    
    Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub

Use ALT / F11 to get to the VBEditor. From there you can comment out the
two commands in ThisWorkbook, save the workbook, then close it.

When you reopen the workbook the menu will be available again allowing you to
work on the contents.