Use names not index, it is more resilient as index could change, and there
is no Disabled property, just Enabled.

Commandbars("Worksheet Menu
Bar").controls("myMenu").controls("mySubMenu1!).En abled= True

and

Commandbars("Worksheet Menu
Bar").controls("myMenu").controls("mySubMenu1!).En abled= False

--
HTH

Bob Phillips

"lehainam" wrote in
message ...

Dear Rowan,

Thanks for your advice. However it does not work on my Menu. It only
works on standard Menu of Excel.

For example: If the index of my menu is 13 and i want to disable 1st
sub menu of my menu, it does not work

Commandbars(1).controls(13).controls(1).disabled=f alse

But for Excel Menu it works,

Commandbars(1).controls(1.controls(1).disabled=fal se

Could you help me!

Thanks,

Nam


--
lehainam
------------------------------------------------------------------------
lehainam's Profile:
http://www.excelforum.com/member.php...o&userid=18615
View this thread: http://www.excelforum.com/showthread...hreadid=387052