excel vba question

[joost]

Hello,

How can you hide the option dialog box in Excel (2003) (Tools - Option).
Which VBA code can be used or is this possible through protection.

Thanks

Groet
Joost

 

[Bob Phillips]

Application.Commandbars("Worksheet Menu
Bar").Controls("Tools").Controls("Options").Enabled = False

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[joost]

thanks

Application.Commandbars("Worksheet Menu
Bar").Controls("Tools").Controls("Options").Enabled = False

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)