A Macro to Run Other Macros
This night's tip shows how to run the four macros mentioned back in February to simultaneously help format data on all worksheets of an Excel spreadsheet.
The macro to paste the values of all formulas on February 29, 2016.
The macro to unfilter data on February 25, 2016.
The macro to autofit colums and rows on February 20, 2016.
The macro to unfreeze on February 17, 2016.
You just need to insert this macro in a new module and edit it to refer to the macros you want to run. So:
Sub option1() macro1 macro2 macro3 End Sub Sub option2() Call macro1 Call macro2 Call macro3 End Sub
. . . becomes in this Night's example:
Sub option1() AutoFitAll UnFreeze Unfilter PasteValue End Sub
Sub option2() Call AutoFitAll Call UnFreeze Call Unfilter Call PasteValue End Sub
Follow the instructions provided on my YouTube channel.
Thanks to AJ for this tip at http://www.mrexcel.com/forum/excel-questions/11487-execute-multiple-macros.html