Disabling Menu Options

  • Thread starter Thread starter Neil Warwick
  • Start date Start date
N

Neil Warwick

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!
 
Neil,

Add another control level

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

--

HTH

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