Hi Ron,


Sorry for a late reply - got my head in this XL2007 all day :-)


Got it working - thanks :-)


CE
Ron de Bruin wrote:
You can use this but it also hide the QAT
You must use ribbonx in the file if you want to see the QAT (post
back if you want a example)
Sub HideRibbon()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub


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


"Charlotte E" <@ wrote in message
...
How to do it?!?


CE