Private Sub Commandbutton1_click()
macro1
macro2
macro3
.. . .
macro14
macro15
end Sub

just call the macros sequentially.

--
Regards,
Tom Ogilvy

"Ctech" wrote in
message ...

I have made 15 different macroes, which is part of a report macro.


I want the Userform OK button, to start the macro and then run through
all the macroes.

however my problem now is that the macro stops after the first End
Sub.
Is there a way to tell the macro to start directly on the next "Sub
macro2 ()" .



Thanks


--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=474743