If you add the reference manually (Tools -> References) when the file is distributed then assuming the same library is available on the other clients the library will be available.

You can add references via the Workbook Open event but unless there are version specific issues with the library itself it's often not necessary.