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
Menu Macro Not Executing - Need Help 1
Disable Cut/Copy/Paste in Excel 2010 0
how to disable Public function macro's 1
Command Bar Tools, Protection Protect & Share ID 5
disabling specific items under tools menu 0
Workbook_Open() won't run macro unless breakpoint set 1

Top