Admit, I was hoping not to do that. Oh well, thanks for your responses.

"Tom Ogilvy" wrote in message
...
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