Use the Ole's add-in

You can find the link on this page
http://www.rondebruin.nl/menuid.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"cm" wrote in message ...
Hello

I need to disable the Tools/Customizze menu option and I need to know the
'ID' for this command -- and where do I find the list of those IDs?


example for disabling Tools/Options command:
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=522, Recursive:=True).Enabled = False

cm