I need to hide/redisplay (turn off or on) Excel's ribbon and quick access
toolbar from within a macro. This was easy enough in the older Excels but I
can't figure it out in Excel 2007. If I turn them off and on directly while
recording, all I get is a blank maco. Any help out there? Thanks!

--Ken

toggle with Ctrl + F1

On Oct 23, 7:08*am, "Ken" wrote:
I need to hide/redisplay (turn off or on) Excel's ribbon and quick access
toolbar from within a macro. This was easy enough in the older Excels but I
can't figure it out in Excel 2007. *If I turn them off and on directly while
recording, all I get is a blank maco. *Any help out there? *Thanks!

--Ken

Hi Ken

If it is for the whole ribbon use

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


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


See also this page
http://www.rondebruin.nl/hidevisible.htm

Or on MSDN
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

And part 2
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx








--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ken" wrote in message ...
I need to hide/redisplay (turn off or on) Excel's ribbon and quick access
toolbar from within a macro. This was easy enough in the older Excels but I
can't figure it out in Excel 2007. If I turn them off and on directly while
recording, all I get is a blank maco. Any help out there? Thanks!

--Ken