Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Place a tick in a drop down menu
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop dwn menu. Formula to count selection frm menu in anoth cell? | Excel Worksheet Functions | |||
filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
How to get a tick in a drop down menu | Excel Programming | |||
Hiding a cell's drop-down menu, dependent on a tick-box selection... | Excel Discussion (Misc queries) | |||
how can i place the Format Painter icon on the Context menu? | Excel Discussion (Misc queries) |