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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message ...
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" wrote in message
...
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" wrote in message
...
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?