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?