UDF & Add-In question.

[Darren Bartrup]

I've built a UDF which I saved as an add-in and distributed.

I've now noticed that when a workbook is opened by another user the function shows as:

='C:\Documents and Settings\darren.bartrup\Application Data\Microsoft\AddIns\AddressSplitter.xla'!SplitAddress(F11,,,,,TRUE)

They are using the add-in as well and I was kind of hoping it would reference their copy, rather than try and reference mine.

Am I doing something wrong, or does the UDF need to be contained within the workbook?

 

[Andrew Poulsom]

Look here:

http://www.jkp-ads.com/Articles/FixLinks2UDF.asp

 

[Darren Bartrup]

Some good stuff in the link.
Thanks for that Andrew, I'll be able to solve the problem before it arises in future.