PDA

View Full Version : Solved: ShowHideMinimize Ribbon using VBA



tengkurap
12-21-2008, 05:57 AM
Hello!,

Is there a way using VBA to minimize the Ribbon in Excel 2007 and
disable maximize for a specific worksheet.

I find a way to hide the ribbon completely using eexecute excel4macro
but it hides even the munu.

thanks,

Simon Lloyd
12-21-2008, 10:05 AM
Try this to show & hide the ribbon:


Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub
Sub ShowRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"
End Sub