Yahoo Answers is shutting down on 4 May 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
how to run different Excel macros one after the other?
I have built a series of macros; Macro 1, Macro 2, Macro 3 and so on. How do I instruct excel to run Macro 2 when Macro 1 is done running?
When writing them I tend to break down the project into smaller pieces.
I would prefer not to merge them together.
There is an Application.Run command that fires off another macro. Thanks for the help.
3 Answers
- Risk-averseLv 51 decade agoFavourite answer
Simple solution. You can have a "Macro seuencer" macro to call them in the sequence you wish. Record another macro that does anything (since you don't want the function you record), stop recording, then go to edit the macros. In your macro sequencer, delete the code you just recorded and replace with "call macro1, "call macro2", ..., in the proper sequence.
- 8 years ago
Running a macro of the macros worked pretty good for me.
So...
Crate a macro,
start recording
run the first macro
run the second macro
stop recording your master macro
- 1 decade ago
simple man, for MS excel 2007 go to macros-> run and select the next macro. u can do it from quick access menu also. hope this solves ur problem.
Source(s): self knowledge
