Procedure to list subs and fuctions in a custom xla

[Michael]

I am looking for a routine to list the subs and fuctions in an add-in
that I always load. Wanted a quick way to list the custom fuctions I
have written over the years. It seems like VBAproject and
VBAcomponents should come into play but I cant seem to get anything to
work.

Any ideas?

Thanks

 

[joel]

On chip pearson's webpage ('Programming In The VBA Editor'
(http://www.cpearson.com/Excel/vbe.aspx))

There is a section labeled :

Listing All Modules In A Project