Re: Disabling Specific Menu Bar Choices
- From: "Bob Phillips" <bob.NGs@xxxxxxxxxxxxx>
- Date: Mon, 20 Aug 2007 17:54:03 +0100
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?
.
- Prev by Date: Re: Rolling back 'folders delete' using VBA
- Next by Date: runtime error 9 out of range subscript
- Previous by thread: Re: Rolling back 'folders delete' using VBA
- Next by thread: Re: Disabling Specific Menu Bar Choices
- Index(es):
Loading
