Thanks! I should have thought of that. Is there a way to automate it or do
I have to tell anyone who I share the addin with that they may need to do
this?

Thanks again.
Dave


"Jim Rech" wrote:

Your friend can use Edit, Links, Change Source to point to the location of
the add-in on his machine.

--
Jim Rech
Excel MVP
"dave k" wrote in message
...
|I have an addin I created that has some user defined functions (udf). They
| work great. My only problem is that I sent the addin and a spreadsheet
that
| utilized the udf's in the addin to a friend. When he opened up the
related
| spreadsheet, it gave errors and pointed to the location of the addin on my
| computer. Is there a way to eliminate the direct references so Excel will
| see the addin on his computer and use the functions in the local addin and
| not return an error?
|
| Thanks!