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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

VB Script for Excel - 23 Mar 2006 06:11 GMT

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

Reply to this Message

ABG - 23 Mar 2006 07:15 GMT

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.

> 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,
[quoted text clipped - 7 lines]
> Thanks
> Dhaval K

Reply to this Message

Ardus Petus - 23 Mar 2006 07:17 GMT

sub stepAll
Step1
Step2
Step3
Step4
end sub

HTH
--
AP

> 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,
[quoted text clipped - 7 lines]
> Thanks
> Dhaval K

Reply to this Message