Solved: ShowHideMinimize Ribbon using VBA

[tengkurap]

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]

Try this to show & hide the ribbon:
[VBA]

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

[/VBA]