vb code for running macro from toolbutton
 

have assigned a toolbutton to a macro but cannot come up with the right code
to activate the macro(click button) from another macro. That was simple in
Excel 4 but I guess MS wanted to confuse more people with VB.

vb code for running macro from toolbutton
 

Just call the macro, no need to concern yourself with the button click.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"MAXIM" wrote in message
...
have assigned a toolbutton to a macro but cannot come up with the right
code
to activate the macro(click button) from another macro. That was simple
in
Excel 4 but I guess MS wanted to confuse more people with VB.