Anyone know why this wont work?
 

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

Comes up with an error message, it is in the Onopen code of the workbook.

Any suggestions much appreciated, thks, regards, Mark

Anyone know why this wont work?
 

Hi Mark

You can't use Visible with the Worksheet Menu Bar
Use Application.CommandBars("Worksheet Menu Bar").Enabled = False if you want to hide it

More info here
http://www.rondebruin.com/menuid.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mark Stephens" wrote in message ...
Application.CommandBars("Worksheet Menu Bar").Enabled = True
Application.CommandBars("Worksheet Menu Bar").Visible = False

Comes up with an error message, it is in the Onopen code of the workbook.

Any suggestions much appreciated, thks, regards, Mark

Anyone know why this wont work?
 

Dear Ron,

Thanks for your input, appreciate it, rgds, Mark


"Ron de Bruin" wrote in message
...
Hi Mark

You can't use Visible with the Worksheet Menu Bar
Use Application.CommandBars("Worksheet Menu Bar").Enabled = False if you
want to hide it

More info here
http://www.rondebruin.com/menuid.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Mark Stephens" wrote in message
...
Application.CommandBars("Worksheet Menu Bar").Enabled = True
Application.CommandBars("Worksheet Menu Bar").Visible = False

Comes up with an error message, it is in the Onopen code of the workbook.

Any suggestions much appreciated, thks, regards, Mark