Thread: how to create a macro that runs other macro in the same workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MD MD is offline
external usenet poster
  
Posts: 9
Default how to create a macro that runs other macro in the same workbook
Sub step0()

Application.Run (MyWorkbook.xls!step2)
Application.Run (MyWorkbook.xls!step2)
Application.Run (MyWorkbook.xls!step3)
Application.Run (MyWorkbook.xls!step4)

End Sub

Sub step1()

End Sub

Sub step2()

End Sub

and so on


"VB Script for Excel" wrote in message
oups.com...
I have a workbook that has 4 macros. Macros are named as "Step1",
"Step2", "Step3", "Step4".
How can I create a macro in the same file that would run Step1 to Step
4 in consecutive order?

Thanks
Dhaval K



Reply With QuoteReply With Quote