View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mark Stephens Mark Stephens is offline
external usenet poster
 
Posts: 124
Default 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