View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andrew Kennard Andrew Kennard is offline
external usenet poster
 
Posts: 5
Default Enable/Disable Menu Items

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