Hiding and showing only the menu bar with vba

[acousticlife81]

I was wondering if anyone knows how to hide the formula bar and ribbon in vba?

Thanks,

-J

 

[Momentman]

I know you can hide the formula bar with this

Application.DisplayFormulaBar=False

For the ribbon, I would love to see what the code would be

 

[My Aswer Is This]

I use this to Toggle the Ribbon form on to off or off to on

If Application.ExecuteExcel4Macro("Get.ToolBar(7,""Ribbon"")") Then
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", False)"
Else
Application.ExecuteExcel4Macro "Show.ToolBar(""Ribbon"", True)"
End If
End Sub