how to detect which macros are no longer in use?

J

Jack Sons

Hi all,

Over the years I created a lot of macros, some in modules of certain
"normal" xls files, others in my personal.xls. In some cases there are more
than macro in one module. I use XP and Excel 2000. Only "normal" modules are
used.

Some procedures call other macros which are not necessarily in the same
module. I want to get rid of macros I don't need, but need a method (a
macro?) that shows me wether a macro is called for in one or more other
macros and also shows me which macros they are.

I have no idea how to accomplish this. Your help will be much appreciated.

Jack Sons
The Netherlands
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

why the macro is not included in the list? 3
Use a variable in a ShapeRange.Increment 0
ECHO OFF applying to MULTIPLE Macros or MODULES! 1
How to access macros via tool buttons? 2
how to prevent macros in Personal.xls appearing in other workbook 3
Macros to check whether all cells are filled 0
no worksheets in a workbook - Excel 2003 1
Enabling Macros message when NO macros in workbook 3

Top