| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't see list of macros | Excel Discussion (Misc queries) | |||
| Procedures/Macros in the list of Macros | Excel Programming | |||
| Can VBA be used to list macros | Excel Programming | |||
| Macros not appearing in the Tools Macro Macros list | Excel Programming | |||
| List the Macros that can be executed from Tools-Macros | Excel Programming | |||
Linear Mode
