Is there a way to start a macro and have it run through all the modules? Jessi
J Jessi Jul 29, 2003 #1 Is there a way to start a macro and have it run through all the modules? Jessi
D David McRitchie Jul 29, 2003 #2 Hi Jessi, Do you mean start each subroutine, or do you mean create a list of all modules ? If you mean to run, do you mean from the same workbook, and surely the order they are run in would make a difference. If you just want a list of module names Subroutine and Function Table for Open Workbooks (#ListFunctionsAndSubs) within http://www.mvps.org/dmcritchie/excel/buildtoc.htmListFunctionsAndSubs
Hi Jessi, Do you mean start each subroutine, or do you mean create a list of all modules ? If you mean to run, do you mean from the same workbook, and surely the order they are run in would make a difference. If you just want a list of module names Subroutine and Function Table for Open Workbooks (#ListFunctionsAndSubs) within http://www.mvps.org/dmcritchie/excel/buildtoc.htmListFunctionsAndSubs
