View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neil Warwick Neil Warwick is offline
external usenet poster
 
Posts: 1
Default Disabling Menu Options

Can anyone out there help me with a small problem?

I want to disable some of the menu commands to aid
security in my workbook, and also to stop users meesing
up my application.

I have used the following piece of code:-

CommandBars("Worksheet Menu Bar").Controls
("File").Enabled = False

But this diables the whole 'File' menu, I just want to
disable certain options, such as 'Print', I suppose it's
a variation on the above line, but I just cant work it
out!