Run multiple Sub with one click in VBA

Hello All,
I have written different sub (methods) to perform different action on my excel file. So far I been running them manually mean, go to each sub and click run button to run that sub. Now I would like to automate them. Can somebody help me as how do I do that?
BTW I'm new to the VBA.

Thank you.

Thanks for your quick reply. Will these run in the order they are called right? Now let's say one of the macro runs longer time to run or do I need to do anything special in between the macros to make sure the previous one ran successfully?

Thanks again.

Thanks for your all help. Now if I can add little more to my original questions.

I run Crystal report and then export the output the excel. Then open a VB Window and paste all these macros and run the last macro (which will call all other macros). Is there a way to save all these macros in a file (somewhere on network drive) and whenever I run my crystal report and export the output to the excel, once that part is done then these macros will run in newly created excel file, instead of following all those manual steps.
Any help will be appreciated.

Thanks..

Have a read on how to use Personal.xlsb

Hello,
Thanks for your reply. I found a document on how to setup/use personal.xlsb, and by following it I set it up. I have total of 30 macros, plus one Master macro, which runs all those 30 macros. Now if I them manually then those work fine. But if I set them up in personal.xlsb then some of the macros do not run and do not see any error as well, so any idea as what is not setup or missing here?

Thanks again.

Instead of a so called Master Macro, if you call Macro1, it will run all the macros as they are called, one after the other.
We don't know your macros so we can't see what could possibly be the problem.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.