Hide or minimize Ribbon but show Quick Accsess Toolbar in VBA code

[joelin]

Hi all,

Is there a way using VBA to minimize the Ribbon in Excel 2007 and
disable maximize for a specific worksheet.

I find a way to hide the ribbon completely using eexecute excel4macro
but it hides even the munu.
I want to hide the ribbon but QAT is show on

thanks,


Sub HideRibbon()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"

End Sub



Sub ShowRibbon()

Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",True)"

End Sub

 

[VoG]

Not ideal but it works

Sub hide_unhide_Ribbons()
Application.SendKeys ("^{F1}")
End Sub

 

[joelin]

Thanks Mr Vog
Now the code is working
Thanks for your help

 

[EXCELTOEXCEL]

this doesnt work for me. the "F1" key pulls up the office help menu?

 

[EXCELTOEXCEL]

Duh.. I got it..

 

[VoG]

That code mimics CTRL + F1.

 

[ayazgreat]

Hi VoG

How do we maximize or unhide the Ribbion through macro once it minimized

 

[Trevor G]

Ctrl + F1 is the toogle switch to either hide or unhide

 

[ayazgreat]

ok i got it
thnaks

 

[DeepField]

Good afternoon,

I got here quite late, but maybe you can help me. The Ctrl+F1 combo toggles the ribbon on and off, but I only want to run it if it is visible, because otherwise it is already how I want it.

How can I tell (from code) if the ribbon is on or off?

Thank you.

DeepField