Unless the others are using an earlier version of Office than you're using, they shouldn't be getting the error. If they do use an earlier version of Office than you use, simply set the reference on a PC using the earliest version of Office you need to support, then distribute that workbook. Otherwise, a significant re-write of the code would be required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]