open worksheet without menus

S

sgeels

I created a form in Excel. I want to be able to open the form (worksheet)
without any menu bars being visible.

I tried creating a Workbook_Open macro with the following command but it
doesn't work:

Application.CommandBars("Worksheet Menu Bar").Visible = False

The error message is: "Method 'visible" of object 'CommandBar' failed.
 
G

Gord Dibben

Try

Application.CommandBars("Worksheet Menu Bar").Enabled = False


Gord Dibben Excel MVP
 

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_open not executing 3
Use VBA to change &File Control in Worksheet Menu Bar 0
auto enable macros 5
MAJOR PROBLEM! --- Menu Bars don't unhide? 9
Hide menus etc in Excel 2007 5
SAVE AS... WITHOUT COPYING THISWORKBOOK MACRO´S 2
Custom Menus and OnAction 4
Hide the close X in excel 2

Top