One Macro that runs other macros in other workbooks

[mlarson]

Hi all, I have multiple workbooks (let's say they are named WORK2,WORK3,WORK4,etc.) that each contain macros (named WORK2mac,WORK3mac,etc.). And I have one workbook (let's call it WORK1) that contains one macro (WORK1mac). My question is, what would the code be for the macro WORK1mac so that when it is run it would automatically run all the other macros in the other workbooks? And would this work if all workbooks are closed except the WORK1 workbook?

Thanks so much,
Mark

 

[mlarson]

I should also add that I would like the macro that runs the other macros to be a button in my worksheet. I know how to create the button but just thought I should mention that in case it causes any problems of which I'm unaware. Thanks in advance for any help you can provide!