I assume that the CommandButton_Click is an event in a worksheet?

So make it public, and call with

Call Sheet1!CommandButton1_Click

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Boban" wrote in
message ...

How to run sub from sub?

I want to run for example CommandButton1_Click() from other control
sub.


--
Boban
------------------------------------------------------------------------
Boban's Profile:
http://www.excelforum.com/member.php...o&userid=28560
View this thread: http://www.excelforum.com/showthread...hreadid=482541