programmernovice formulated on Tuesday :
Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. Then a drop-down menu appears and a selection must
be made from it by the macro. Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? Many thanks in advance.
Try...
CommandBars(1).Controls("MainMenuName").Controls(" SubMenuName").Execute
(Substitute the obvious expressions with actual menu text)
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc