hide formula bar (and menu bar etc)

  • Thread starter Thread starter pswanie
  • Start date Start date
P

pswanie

what would i add to hede the formula bar?

i tried to use

Application.CommandBars("worksheet formula bar").Enabled = False

but get a error

this is what i got under workbook open

Application.CommandBars("worksheet menu bar").Enabled = False
Application.CommandBars("standard").Enabled = False
Application.CommandBars("formatting").Enabled = False
Application.CommandBars("drawing").Enabled = False
 
Application.DisplayFormulaBar = False
what would i add to hede the formula bar?

i tried to use

Application.CommandBars("worksheet formula bar").Enabled = False

but get a error

this is what i got under workbook open

Application.CommandBars("worksheet menu bar").Enabled = False
Application.CommandBars("standard").Enabled = False
Application.CommandBars("formatting").Enabled = False
Application.CommandBars("drawing").Enabled = False
Click to expand...
 
Back
Top