Hi All,

I have an add-in that I have built myself and use on the 3 PC's I have to
use on different sites. I also have a spreadsheet that I use on all 3
sites. The spreadsheet uses macros and UDF's from within the add-in.

All works fine until I move the worksheet from one PC to another, once
loaded on the new PC it requires the "link" to be updated in order to work
(i.e. you have to point it to the location of the add-in on the new pc)

Is there any advice anyone can give in order to make my worksheet more
portable. I do-not want to include the code from the add-in within my
workbook if at all possible.

2 other bits of potentially useful information (1) I have had a go at using
refernces but I presume these are specific to 1 PC?
(2) I don't understand how / when you should use a class module - is this a
potential solution here?

Ta

Andi