Thread: Anyone know why this wont work?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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



Reply With QuoteReply With Quote