Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Tools/Customize menu option
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Tools/Customize menu option
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Tools/Customize menu option
I thought John Walkenbach had some tool for it.
See The Spreadsheet Page -- Regards; Mark Rosenkrantz -- Spreadsheet Solutions Uithoorn Netherlands -- E: W: www.spreadsheetsolutions.nl -- "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable Tools/Customize menu option
THANK YOU THANK YOU
"Ron de Bruin" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Customize option next to a tool bar from VB | Excel Discussion (Misc queries) | |||
Disable Customize option in toolbar | Excel Programming | |||
disable customize option when right click on menu bar | Excel Programming | |||
disable customize option when right click on menu bar | Excel Discussion (Misc queries) | |||
Disable Option from tools in Menu bar | Excel Programming |