Set worksheet Menu bar invisible

[cathy68]

hi Gurus
I try to set worksheet menu bar invisible in excel. I write the code like this:
Application.Commandbars("Worksheet Menu Bar&quot.Visible = False
in the Workbook_Open() VBA project. it doesn't work.
every time it show a error message:

Run_time error'-2147467259(80004005)':
Method 'Visible' of object 'CommandBar' failed

but if I try
Application.Commandbars("Standard&quot.Visible = False
or any other command bar, it works very well. it looks like only "Worksheet Menu Bar" doesn't work like this way.

is there anyone know why?

 

[MrProgrammer]

Try setting its Enabled property instead of Visible property. worksheet menu bar's index is 1. So the code below works.
Application.CommandBars(1).Enabled = False

 

[cathy68]

Thank you MrProgrammer.