Hi, I have wrote several simplifying user defined formulas related to
structural engineering. I have put these formulas in an excel addin and have
successfully used the formulas to create workbooks on my own computer. I
wanted to distribute these workbooks to other engineers in my office so I
sent them the addin file and the workbooks, and got them to install the addin
file before opening the workbook.

However upon opening the workbook the other engineers found that all of the
userdefined formulas in the workbook reference the Microsoft Addin file on my
own computer. Thus the only way for another user to use the workbook is to
delete the references to my own computer, which is really anoying and negates
the time savings that was gained by programming the formulas.

I think that a solution would be to make Excel look in the addin file on the
users computer for the formulas rather than trying to reference the addin
file on my own computer. Does anyone know how to do this? Or any other
solution??