Even in a workbook, you would have to use the VBE object model to search
through the modules line by line and look for SUB and FUNCTION. So I don't
think the information is made available by Excel and most addins are
probably password protected for their code.

Regards,
Tom Ogilvy

"James" wrote in message
...
This is what I was hoping to do, probably not possible,
but just wondering.

-----Original Message-----
Still not sure -
you mean go through their installed addins and see what
functions those
addins contain?

Regards,
Tom Ogilvy

"James" wrote in
message
...
Maybe I should explain a bit more

basically I want to send a spreadsheet to various users
in different countries that aren't networked that
checks
the users system and reports back via e-mail what
functions they have installed.

All done except for actually getting the list of
functions the user has installed.

It has to be a list of functions and not addins.

Thanks for the previous replies.

James

-----Original Message-----
Is there anyway you can list all the installed
functions
in a spreadsheet?
.



.