hide formula bar (and menu bar etc)

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
 
D

Dave Peterson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

auto enable macros 5
Workbook_close 1
Stripping down excel 2
Shared Workbook 12
Disable formula Bar in Option Menu 3
MAJOR PROBLEM! --- Menu Bars don't unhide? 9
Customise Button on toolbar 1
disable a menu control short key 1

Top