Better to use the ID
http://www.rondebruin.nl/menuid.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Project Mangler" wrote in message ...
Got it thanks:
With Application.CommandBars(1).Controls("File")
.Controls("Print...").Enabled = False
End With
"Project Mangler" wrote in message
...
The following code disables the File menu on the Worksheet Menubar
CommandBars(1).Controls("File").Enabled = True
Ideally I'd like to be able to disable an individual item on the menu e.g.
"Print", but I've struggled to get there.
Can someone please explain how this is achieved?
Thanks.