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!

Disabling Menu Options
 

Neil,

Add another control level

CommandBars("Worksheet Menu
Bar").Controls("File").Controls("Print...").Enable d = False

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Neil Warwick" wrote in message
...
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!