Hi all

I have some code that places a tick in a dropdown menu added to the
menu bar. The code I am using is this :

Application.CommandBars(1).Controls("&Ultimate").C ontrols(12).State =
msoButtonUp

This works really well, however I am now trying to add a tick to a
submenu item as well (in a similar way to the View Toolbars menu item
in Excel) but I just can't get the syntax correct.

Can anyone point me in the right direction?

Thanks

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=561715