I am creating a a shared work book and I don't want the users to have access
to the 'TOOLS' part of the menu bar. I know I can remove just this part of
the menu, but if I do, how will I access when I need to? Is there another
way?

Just disable it

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

and enable when required.

--
---
HTH

Bob

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



"Jase4now" <(E-Mail Removed)> wrote in message
news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
>I am creating a a shared work book and I don't want the users to have
>access
> to the 'TOOLS' part of the menu bar. I know I can remove just this part
> of
> the menu, but if I do, how will I access when I need to? Is there another
> way?

Your response doesn't make complete sense to me. How do I get to the point
where I can access
Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled =
> False

"Bob Phillips" wrote:

> Just disable it
>
> Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled =
> False
>
> and enable when required.
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "Jase4now" <(E-Mail Removed)> wrote in message
> news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
> >I am creating a a shared work book and I don't want the users to have
> >access
> > to the 'TOOLS' part of the menu bar. I know I can remove just this part
> > of
> > the menu, but if I do, how will I access when I need to? Is there another
> > way?
>
>
>

maybe you'll try to use a button hidden somewhere from user's eyes to
disable/enable the tools menu, eg: runing the below mentioned code

"Jase4now" wrote:

> Your response doesn't make complete sense to me. How do I get to the point
> where I can access
> Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled =
> > False
>
> "Bob Phillips" wrote:
>
> > Just disable it
> >
> > Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled =
> > False
> >
> > and enable when required.
> >
> > --
> > ---
> > HTH
> >
> > Bob
> >
> > (there's no email, no snail mail, but somewhere should be gmail in my addy)
> >
> >
> >
> > "Jase4now" <(E-Mail Removed)> wrote in message
> > news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
> > >I am creating a a shared work book and I don't want the users to have
> > >access
> > > to the 'TOOLS' part of the menu bar. I know I can remove just this part
> > > of
> > > the menu, but if I do, how will I access when I need to? Is there another
> > > way?
> >
> >
> >

Can somebody please, tell me where I need to type the code to disable the
TOOLS menu without removing it?

"catrrmg" wrote:

> maybe you'll try to use a button hidden somewhere from user's eyes to
> disable/enable the tools menu, eg: runing the below mentioned code
>
> "Jase4now" wrote:
>
> > Your response doesn't make complete sense to me. How do I get to the point
> > where I can access
> > Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled =
> > > False
> >
> > "Bob Phillips" wrote:
> >
> > > Just disable it
> > >
> > > Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled =
> > > False
> > >
> > > and enable when required.
> > >
> > > --
> > > ---
> > > HTH
> > >
> > > Bob
> > >
> > > (there's no email, no snail mail, but somewhere should be gmail in my addy)
> > >
> > >
> > >
> > > "Jase4now" <(E-Mail Removed)> wrote in message
> > > news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
> > > >I am creating a a shared work book and I don't want the users to have
> > > >access
> > > > to the 'TOOLS' part of the menu bar. I know I can remove just this part
> > > > of
> > > > the menu, but if I do, how will I access when I need to? Is there another
> > > > way?
> > >
> > >
> > >

Anywhere! Wherever you need that functionality!

--
---
HTH

Bob

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



"Jase4now" <(E-Mail Removed)> wrote in message
newsA96E582-B0C6-4A3C-BA7E-(E-Mail Removed)...
> Can somebody please, tell me where I need to type the code to disable the
> TOOLS menu without removing it?
>
> "catrrmg" wrote:
>
>> maybe you'll try to use a button hidden somewhere from user's eyes to
>> disable/enable the tools menu, eg: runing the below mentioned code
>>
>> "Jase4now" wrote:
>>
>> > Your response doesn't make complete sense to me. How do I get to the
>> > point
>> > where I can access
>> > Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled
>> > =
>> > > False
>> >
>> > "Bob Phillips" wrote:
>> >
>> > > Just disable it
>> > >
>> > > Application.Commandbars("Worksheet Menu
>> > > Bar").Controls("Tools").Enabled =
>> > > False
>> > >
>> > > and enable when required.
>> > >
>> > > --
>> > > ---
>> > > HTH
>> > >
>> > > Bob
>> > >
>> > > (there's no email, no snail mail, but somewhere should be gmail in my
>> > > addy)
>> > >
>> > >
>> > >
>> > > "Jase4now" <(E-Mail Removed)> wrote in message
>> > > news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
>> > > >I am creating a a shared work book and I don't want the users to
>> > > >have
>> > > >access
>> > > > to the 'TOOLS' part of the menu bar. I know I can remove just this
>> > > > part
>> > > > of
>> > > > the menu, but if I do, how will I access when I need to? Is there
>> > > > another
>> > > > way?
>> > >
>> > >
>> > >

Well, Either your formula is wrong, or telling me to put it anywhere is
wrong! I am not a programmer, so I don't understand what may be 'common
knowledge' to you. I am thinking that it must be put into the VB, but
everywhere I put it, it just turns red and does not work. Is their another
step I am missing?

"Bob Phillips" wrote:

> Anywhere! Wherever you need that functionality!
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "Jase4now" <(E-Mail Removed)> wrote in message
> newsA96E582-B0C6-4A3C-BA7E-(E-Mail Removed)...
> > Can somebody please, tell me where I need to type the code to disable the
> > TOOLS menu without removing it?
> >
> > "catrrmg" wrote:
> >
> >> maybe you'll try to use a button hidden somewhere from user's eyes to
> >> disable/enable the tools menu, eg: runing the below mentioned code
> >>
> >> "Jase4now" wrote:
> >>
> >> > Your response doesn't make complete sense to me. How do I get to the
> >> > point
> >> > where I can access
> >> > Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled
> >> > =
> >> > > False
> >> >
> >> > "Bob Phillips" wrote:
> >> >
> >> > > Just disable it
> >> > >
> >> > > Application.Commandbars("Worksheet Menu
> >> > > Bar").Controls("Tools").Enabled =
> >> > > False
> >> > >
> >> > > and enable when required.
> >> > >
> >> > > --
> >> > > ---
> >> > > HTH
> >> > >
> >> > > Bob
> >> > >
> >> > > (there's no email, no snail mail, but somewhere should be gmail in my
> >> > > addy)
> >> > >
> >> > >
> >> > >
> >> > > "Jase4now" <(E-Mail Removed)> wrote in message
> >> > > news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
> >> > > >I am creating a a shared work book and I don't want the users to
> >> > > >have
> >> > > >access
> >> > > > to the 'TOOLS' part of the menu bar. I know I can remove just this
> >> > > > part
> >> > > > of
> >> > > > the menu, but if I do, how will I access when I need to? Is there
> >> > > > another
> >> > > > way?
> >> > >
> >> > >
> >> > >
>
>
>

See also
http://www.rondebruin.nl/menuid.htm

If you are new to VBA read this page
http://www.mvps.org/dmcritchie/excel/getstarted.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Jase4now" <(E-Mail Removed)> wrote in message news:99B783D5-0D05-4CE4-99FE-(E-Mail Removed)...
> Well, Either your formula is wrong, or telling me to put it anywhere is
> wrong! I am not a programmer, so I don't understand what may be 'common
> knowledge' to you. I am thinking that it must be put into the VB, but
> everywhere I put it, it just turns red and does not work. Is their another
> step I am missing?
>
> "Bob Phillips" wrote:
>
>> Anywhere! Wherever you need that functionality!
>>
>> --
>> ---
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>>
>>
>>
>> "Jase4now" <(E-Mail Removed)> wrote in message
>> newsA96E582-B0C6-4A3C-BA7E-(E-Mail Removed)...
>> > Can somebody please, tell me where I need to type the code to disable the
>> > TOOLS menu without removing it?
>> >
>> > "catrrmg" wrote:
>> >
>> >> maybe you'll try to use a button hidden somewhere from user's eyes to
>> >> disable/enable the tools menu, eg: runing the below mentioned code
>> >>
>> >> "Jase4now" wrote:
>> >>
>> >> > Your response doesn't make complete sense to me. How do I get to the
>> >> > point
>> >> > where I can access
>> >> > Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Enabled
>> >> > =
>> >> > > False
>> >> >
>> >> > "Bob Phillips" wrote:
>> >> >
>> >> > > Just disable it
>> >> > >
>> >> > > Application.Commandbars("Worksheet Menu
>> >> > > Bar").Controls("Tools").Enabled =
>> >> > > False
>> >> > >
>> >> > > and enable when required.
>> >> > >
>> >> > > --
>> >> > > ---
>> >> > > HTH
>> >> > >
>> >> > > Bob
>> >> > >
>> >> > > (there's no email, no snail mail, but somewhere should be gmail in my
>> >> > > addy)
>> >> > >
>> >> > >
>> >> > >
>> >> > > "Jase4now" <(E-Mail Removed)> wrote in message
>> >> > > news:5EAB0E3B-5598-4FD4-807B-(E-Mail Removed)...
>> >> > > >I am creating a a shared work book and I don't want the users to
>> >> > > >have
>> >> > > >access
>> >> > > > to the 'TOOLS' part of the menu bar. I know I can remove just this
>> >> > > > part
>> >> > > > of
>> >> > > > the menu, but if I do, how will I access when I need to? Is there
>> >> > > > another
>> >> > > > way?
>> >> > >
>> >> > >
>> >> > >
>>
>>
>>