Hi,

I would like to know if there is a way of getting a list of all
userdefined functions which are defined in all vba add-in's open.

You can get
worksheet functions from Application.WorksheetFunctions
registered xll functions from Application.RegisteredFunctions

but what about vba functions?

Thanks,
Dave

Dave,

I think you would have to scan the VBA project and extract all functions.
Even that might be flawed as some VBA functions are not usable in a
worksheet, if they update other sheet attributes for instance.

--
HTH

Bob Phillips

"David Welch" wrote in message
...
Hi,

I would like to know if there is a way of getting a list of all
userdefined functions which are defined in all vba add-in's open.

You can get
worksheet functions from Application.WorksheetFunctions
registered xll functions from Application.RegisteredFunctions

but what about vba functions?

Thanks,
Dave