Hide the menu

Application.Commandbars("Worksheet Menu Bar").Controls("Tools").Visible
= False

to disable a particular sub-menu

Application.Commandbars("Worksheet Menu
Bar").Controls("Tools").Controls("Add-Ins...").enabled=false

-

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Rich Cooper" wrote in message
...
I have a question regarding diabling the tools menus. I want to know is
there a way i can diable a use from clickon on tools and the menu won't
show
up or if you can gray out certain or all the buttons? Any help is greatly
appreciated.