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?