Any way to see timestamp of WHEN a macro was last run? (to get rid of stale macros)

[d0rian]

All a google search turned up was code that I could put into a macro that will essentially save a log of when it runs, but seems to only be forward-looking. I.e. will keep a log of all times that macro runs going forward, but I'm trying to clean up my Modules and want to get rid of all the macros I no longer use, so I want to know if it's possible to generate a list of the ~100 or so Macros I've created over the last couple years, and generate the time each of them last ran in the adjacent column (so I can view / delete anything that I haven't run in...say, 3+ months.)

 

[Fluff]

Not that I'm aware of.

 

[mole999]

Not a list, but you can easily add a line that updates a tracking sheet on the sub name as a stamp, and not all subs will be redundant as being called by others