disable Tools/Customize menu option

C

cm

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
 
S

Spreadsheet Solutions

I thought John Walkenbach had some tool for it.

See The Spreadsheet Page
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

disable Edit/Cut menu option (and other specific ones) 1
Disable formula Bar in Option Menu 3
Menus in Excel 2007 20
Disable Tools > Protection 3
CommandBar 'Insert' 2
What am I doing wrong? 2
disable a menu control short key 1
disable shortcut key from menu control 1

Top