how to list calls to macros?
 

I am trying to sort out some files containing many macros, which were
written originally (not by myself) for a previous version of Excel.
Some of the files contain macro code which is not relevant to that
file, because the file has been created from another file, and then
modified - leaving unnecessary code in there.
Is it possible to print out a list of all calls to macros from within a
workbook, including a 'tree' which would help me to spot which code is
not required?

how to list calls to macros?
 

Rob Bovey has created a Code Documentor utility that may help you.

http://www.appspro.com/Utilities/Documentor.htm

--
Jim
"iahaining" wrote in message
oups.com...
|I am trying to sort out some files containing many macros, which were
| written originally (not by myself) for a previous version of Excel.
| Some of the files contain macro code which is not relevant to that
| file, because the file has been created from another file, and then
| modified - leaving unnecessary code in there.
| Is it possible to print out a list of all calls to macros from within a
| workbook, including a 'tree' which would help me to spot which code is
| not required?
|