Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Commandbars("Custom 2").Controls(3).Controls(2).Enabled = False
worked for me. -- Regards, Tom Ogilvy "Andrew Kennard" wrote in message ... Hi all I've created my own custom menu and added items to it. eg My Menu, Item1, Item 2 etc I would like to be able to change the enabled property of each item inside certain subs. But no matter what I try I can't seem to 'get a hold' on the ITEM to change it's state ? I have sucessfully changed the state of the MENU to enabled true/false but not indiviual items. I've done lots of googling but still have no luck with simlar 'delete' examples that I presume should work. The main problem sees to be even adding Tag properties I cannot use FindControls to find an ITEM TIA Andrew |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks for that
Now got it working ...... the problem (very strange) seems to be if the Tag value is "PB" it does not work ??? ie FindControl doesn't find it ? TIA Andrew "Tom Ogilvy" wrote in message ... Commandbars("Custom 2").Controls(3).Controls(2).Enabled = False worked for me. -- Regards, Tom Ogilvy "Andrew Kennard" wrote in message ... Hi all I've created my own custom menu and added items to it. eg My Menu, Item1, Item 2 etc I would like to be able to change the enabled property of each item inside certain subs. But no matter what I try I can't seem to 'get a hold' on the ITEM to change it's state ? I have sucessfully changed the state of the MENU to enabled true/false but not indiviual items. I've done lots of googling but still have no luck with simlar 'delete' examples that I presume should work. The main problem sees to be even adding Tag properties I cannot use FindControls to find an ITEM TIA Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to enable items on Excel draw menu bar. | Excel Discussion (Misc queries) | |||
Is is possible to disable certain menu items | Excel Programming | |||
Disable menu items with VBA | Excel Programming | |||
Menu Items and Disable/Enable in Excel 2003 | Excel Programming | |||
HELP - How do I disable Excels menu items so others can't use | Excel Programming |