VBA: is there any way I can automatically hide or disable the top toolbar upon file opening?

[JulioTheLess]

I made this excel file as a tool by other user, I'm wondering if there's a way to hide or permanently hide the toolbar upon opening the file so that it may look neat and appears to be as a encoding tool.

 

[Michael M]

You could use

Private Sub Auto_Open()
Application.ExecuteExcel4Macro "Show.Toolbar(""Ribbon"",False)"
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = Not Application.DisplayStatusBar
End Sub

 

[JulioTheLess]

You could use

Private Sub Auto_Open()
Application.ExecuteExcel4Macro "Show.Toolbar(""Ribbon"",False)"
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = Not Application.DisplayStatusBar
End Sub

it's work perfectly thank you Sir

 

[Michael M]

glad to help...