Hide Ribbon on Workbook Open

**HangMan** · 07-10-2012, 08:13 PM

I'm using this code to hide the ribbon when my workbook opens, but how do I make it unique to this workbook only? At the moment, the ribbon appears hidden in all workbooks.

Private Sub Workbook_Open()
    Application.ExecuteExcel4Macro "Show.Toolbar(""Ribbon"",False)"
End Sub

Private Sub Workbook_Close()
    Application.ExecuteExcel4Macro "Show.Toolbar(""Ribbon"",True)"
End Sub

**abousetta** · 07-10-2012, 08:22 PM

Hi,

Have a look at the code I have posted here. Simple put you will have to add activate and deactivate workbook functions so that Excel know whether or not to show the ribbon.

Let me know if you have any trouble adapting my code.

abousetta

**HangMan** · 07-10-2012, 08:56 PM

abousetta,

Many thanks, that did the trick...

**abousetta** · 07-10-2012, 09:14 PM

Glad it all worked out. If you are satisfied with the results then please mark the thread as solved.

Also we have a competition this month on Excel Forum, please stop by and click on the like button of the tips you find of benefit.

Good luck.

abousetta