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
 

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

Workbook_close 1
Shared Workbook 12
auto enable macros 5
Stripping down excel 2
Disable formula Bar in Option Menu 3
VBA for Dependents shortcut menu 0
Disable Menu Items 2
disable Tools/Customize menu option 3

Top