hide formula bar (and menu bar etc)
 

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

hide formula bar (and menu bar etc)
 

Application.DisplayFormulaBar = False

pswanie wrote:

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

--

Dave Peterson

hide formula bar (and menu bar etc)
 

thanx dave

"pswanie" wrote:

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