I have a user defined function (called FilterCriteria) in an xla file stored
in my AddIns folder (C:\Documents and Settings\username\Application
Data\Microsoft\AddIns) and it works fine in workbooks on my PC. When I send
a workbook that uses the UDF, and the xla file to another user, it doesn't
work on their PC even when the AddIn is registered. The function shows up on
their PC as 'C:\Doc....xla'!FilterCriteria and of course they don't have that
path on their PC. The cells that use the function therefore just have a
#Name? in them.

Is there a way around this? The macros work fine in the xla, so I'm not
sure why the function doesn't. I don't want to put the xla in a seperate
fixed path on each person's PC because I wanted to use the Excel default path
for AddIns (not all our users have access to other paths on their PCs).