Hello,

I have several macros that use the SumByColors function
created by: http://www.cpearson.com/excel/colors.htm

This allows me to sum by color. I have set this up as an
Add-in used by several individuals. When I run one of my
macros that uses this function and then save the file to
my network drive the file continues to link to my C: drive
where the Add-in is stored. When other users (who also
have the Add-in installed on their C: drive) access this
file from our network drive the formulas for the
SumByColor function is still linked to my C: drive. How
can I set up the macro or the Add-in to allow the file to
link to the users C: drive or Add-in and not to the
computer that creates the file (my C: drive).

Any thoughts would be helpful.

Thank you,