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.

Huawei P10 review

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

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now