Help with VB macro for Excel
On Jun 7, 7:06*pm, GS wrote:
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 athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc
Many thanks Garry. Works like a charm.
|