could any one please tell me how can i create a macro that runs other macro

[VB Script for Excel]

How would I create a macro that runs 4 different macros in the same
workbook. Assume the names of those 4 macros as Step1, Step2, Step3,
Step4.

So how would i create another macro (say, name it as StepAll) that
would run sequentially all the 4 macros (i.e. Step 1, 2, 3,4)

HELP

Thanks
Dhaval K

 

[ABG]

The easiest way is to write another macro that calls each of the others.

For example:

sub StepAll()
step1
step2
step3
step4
End Sub

This will run them in the order presented.

 

[Ardus Petus]

sub stepAll
Step1
Step2
Step3
Step4
end sub


HTH