Excel does this internally and does not expose this list. If you want to
get a list, you would need to parse through all you code modules.

You can start by looking at this page on Chip Pearson's site:

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Alan Howells" wrote in message
...
Morning all

Is there anyway to retrieve a list of public functions from a workbook. Or
in other words how does the function wizard get it's list of user-defined
functions from open workbooks.

Thanks in advance,


Alan