On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help