COUNTING MACROS AND CHECKING ON WHICH ONES ARE BEING USED

[Mr_Phil]

Here's a tough one. I have an ancient workbook that easily started life as an Excel 97 or 07. It has a (precision count) bazillion macros. There are so many that I would love a way to list them and then list the last use of them. Then, as I update the workbook I could remove the no longer useful macros. I have no clue how to even approach this. Any ideas?

 

[Joe4]

There is some code here that will create a list of all your macros in a workbook. See here: Generating a List of Macros (Microsoft Excel)

As for when they were last used, I don't think there is any way to do that, as I don't believe it is anything that Excel tracks.
The only possible way I could think of doing that is creating a log file (or sheet in your current workbook), and add code to EVERY macro that logs to this location every time it is run.
That would obviously be a lot of work, as you would have to update EVERY macro, and it would only work from that point forward.

 

[Mr_Phil]

There is some code here that will create a list of all your macros in a workbook. See here: Generating a List of Macros (Microsoft Excel)

As for when they were last used, I don't think there is any way to do that, as I don't believe it is anything that Excel tracks.
The only possible way I could think of doing that is creating a log file (or sheet in your current workbook), and add code to EVERY macro that logs to this location every time it is run.
That would obviously be a lot of work, as you would have to update EVERY macro, and it would only work from that point forward.

Way cool I like the idea of the list and I like the log sheet idea. I think I will copy the workbook and implement both ideas. I'm wondering if I do a control H and replace every instance of "end sub" with "something, control J, end sub" or something like it if that would work. I apologize for the delay between your answer and my response. I had to travel and things got a bit hairy for a short time. Thank you very much for the help.

 

[Joe4]

You are welcome.
Glad I was able to help!