Hide Ribbon in Excel 10

  Desert Andy 14:37 09 Oct 2012
Locked

Hi

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

Andy

  VoG II 15:08 09 Oct 2012

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 09 Oct 2012

Thank you very much, all solved.

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone