View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Project Mangler Project Mangler is offline
external usenet poster
 
Posts: 63
Default Disabling Built-in items on a menu

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.