Microsoft Office Forums


Reply
Thread Tools Display Modes

excel vba question

 
 
joost
Guest
Posts: n/a

 
      06-12-2007, 08:10 AM
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


 
Reply With Quote
 
 
 
 
Bob Phillips
Guest
Posts: n/a

 
      06-12-2007, 09:38 AM
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
>



 
Reply With Quote
 
joost
Guest
Posts: n/a

 
      06-12-2007, 10:52 AM
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
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Question Lavida Excel Newsgroup 2 01-07-2007 06:08 PM
excel question Administrator Excel Newsgroup 2 05-13-2006 01:39 PM
HELP !!!! excel question lushus21 Excel Newsgroup 2 02-13-2006 08:34 AM
Excel vba question levy.pate@baesystems.com Excel Newsgroup 3 12-02-2005 12:40 PM
Excel question Nocturnal Excel Newsgroup 2 07-03-2005 01:25 AM



All times are GMT. The time now is 02:04 PM.