Hide Ribbon in Excel 10

  Desert Andy 14:37 09 Oct 12
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 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 09 Oct 12

Thank you very much, all solved.

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

Surface Pro 5 News - release date, UK price, features, specs

Microsoft Surface Studio hands-on review: the iMac killer is here

Best Mac antivirus 2017