Want to hide the ribbon completely from Excel 2007

[Michael]

I have a solution (.xlsm) I wrote in Excel 2007 and I want to hide the
ribbon as well as anything that will resemble Excel. When I run the file (as
well as the code) I want it to appear that this is more like a Win32
application. Any pointers to some documents to read ?

Thanks
Michael

 

[Ron de Bruin]

Hi Michael

Try this example posted by Jim Rech

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

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