R.B. Smissert posted this in another thread:

This .xla add-in:
http://tinyurl.com/rrw3p
Has an extensive workbook documenter and it will amongst many
other things list all your macro's.



"John" wrote:

I would like to present user with a list of macros with explanations of
what they do. Have one button that is "Macros" and that opens a macro
(or something) that lists the macros. Then can select one to run.

Thanks

John