I have a lot of macros contained in several modules. Not sure how that happened but it now takes a while for me to find any individual macro. I would like to generate a list of all my macros and the modules they are stored in. The list should include Private Subs. I found some solutions which list the macros but they appear to exclude private subs and none show which module the macro is stored in.