Disabling Specific Menu Bar Choices

[Guest]

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?

 

[Bob Phillips]

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)

 

[Guest]

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 =

 

[Guest]

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

 

[Guest]

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

 

[Bob Phillips]

Anywhere! Wherever you need that functionality!

--
---
HTH

Bob

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

 

[Guest]

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?

 

[Ron de Bruin]

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