Want to hide the ribbon completely from Excel 2007

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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
 
Back
Top