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

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

--
HTH

Bob

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

"joost" <(E-Mail Removed)> wrote in message
news:f4lkct$r74$(E-Mail Removed)...
> 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
>

thanks


"Bob Phillips" <(E-Mail Removed)> schreef in bericht
news:%(E-Mail Removed)...
> Application.Commandbars("Worksheet Menu
> Bar").Controls("Tools").Controls("Options").Enable d = False
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
> addy)
>
> "joost" <(E-Mail Removed)> wrote in message
> news:f4lkct$r74$(E-Mail Removed)...
>> 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
>>
>
>