View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie[_2_] David McRitchie[_2_] is offline
external usenet poster
 
Posts: 134
Default running all modules

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...nctionsAndSubs

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jessi" wrote in message om...
Is there a way to start a macro and have it run through all the modules?

Jessi