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

Samsung Galaxy A8 review: Hands-on

Illustrator Juan Esteban Rodriguez on creating highly detailed official film posters for Star Wars…

iMac Pro review

Quelle est la meilleure application de podcast pour Android (2018) ?