Everything suggested here works fine on my system - in
fact the original code caused no errors on mine, its just
when I distribute it and suddenly others in my team have
this error.

I tried removing the library in order to re-add it but
excel claims its in use and won't allow me to uncheck the
box.

Getting rather confused now.

any more ideas?

In Hope.

Craig