I have six macros in a ws which I wish to run sequentially
on one click. Can someone help with macro or vb to do that.

Regards,
JA

if in the same module

Sub Control()
Call macro1
Call macro2
Call macro3
Call macro4
Call macro5
Call macro6
End Sub

if in different module
call module1.marco1

"jamesa" wrote in message
...
I have six macros in a ws which I wish to run sequentially
on one click. Can someone help with macro or vb to do that.

Regards,
JA

here u a

Sub Makro1()
'
End Sub

Sub Makro2()
'
End Sub
....
Sub RnuSequentially()
Makro1
Makro2
End Sub

Regards,
Milos

"jamesa" wrote in message
...
I have six macros in a ws which I wish to run sequentially
on one click. Can someone help with macro or vb to do that.

Regards,
JA