open worksheet without menus
 

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.

open worksheet without menus
 

Try

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


Gord Dibben Excel MVP

On Sun, 23 Oct 2005 15:09:03 -0700, sgeels
wrote:

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.

open worksheet without menus
 

OUTSTANDING! Thanks for the help!

"Gord Dibben" wrote:

Try

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


Gord Dibben Excel MVP

On Sun, 23 Oct 2005 15:09:03 -0700, sgeels
wrote:

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.