Hide Ribbon in Excel 10

  Desert Andy 14:37 PM 09 Oct 12


I would like to know how to write vB code in Exel 10 to hide and unhide the ribbon. Many thanks


  VoG II 15:08 PM 09 Oct 12

Try these

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

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

  Desert Andy 16:08 PM 09 Oct 12

Thank you very much, all solved.


This thread is now locked and can not be replied to.

How to watch Rugby World Cup 2015 online: Watch live, catch up on-demand & stream the 2015 Rugby…

1995-2015: How technology has changed the world in 20 years

See immersive artist and storyteller Chris Milk speak at London VR event

What everyone thinks of the new Steve Jobs movie | 21 Facts about the Steve Jobs film | PLUS:…