A Macro to Run Other Macros

A Macro to Run Other Macros

March 7, 2016

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.

 

 

 

https://youtu.be/R1qa1wjjIAs

 

 

 

 

 

 

 

Thanks to AJ for this tip at http://www.mrexcel.com/forum/excel-questions/11487-execute-multiple-macros.html 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com