I received an add-in to modify thats used in conjunction with another
workbook. When I send the workbook/add-in combination to the individuals
who need to use it, all of the references to the User Defined functions in
the add-in now include a link to where the add-in was saved on my system. I
don't want to have to tell them to take out the path name each time it's sent
to a new person. What needs to be done to fix this?

Thanks,
Barb Reinhardt

You could tell tell them to open the file and fix the links:

Edit|links|Change source
to point at the new location.

But if you want to be nice, you may want to try this:
Create a new folder on your harddrive (C:)
call it: C:\BarbsUtils
Put your addin in that location.

Then when you share the addin with the other folks, tell them to put the addin
in that same location on their system (C:\barbsutils)

And then they could use Tools|Addins (and browse for that addin) to install your
addin.



Barb Reinhardt wrote:

I received an add-in to modify thats used in conjunction with another
workbook. When I send the workbook/add-in combination to the individuals
who need to use it, all of the references to the User Defined functions in
the add-in now include a link to where the add-in was saved on my system. I
don't want to have to tell them to take out the path name each time it's sent
to a new person. What needs to be done to fix this?

Thanks,
Barb Reinhardt

--

Dave Peterson