Re: Disabling Specific Menu Bar Choices

Tech-Archive recommends: Fix windows errors by optimizing your registry

Anywhere! Wherever you need that functionality!

--
---
HTH

Bob

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



"Jase4now" <Jase4now@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DA96E582-B0C6-4A3C-BA7E-77E0391F69EF@xxxxxxxxxxxxxxxx
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("Work*** Menu Bar").Controls("Tools").Enabled
=
False

"Bob Phillips" wrote:

Just disable it

Application.Commandbars("Work*** 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" <Jase4now@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5EAB0E3B-5598-4FD4-807B-954CB45088A0@xxxxxxxxxxxxxxxx
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?





.

Quantcast