I have an Excel workbook that is distributed to users of varying computer literacy and varying versions of Excel and/or Office. This workbook has been distributed to about 25 users and has worked fine except in about four cases. In those cases, when the user initially opens the workbook, an unnumbered compile error occurs "Cannot locate object or project". I think I've traced this error to a userform that contains Calendar Control 10.0, the files for which apparently do not exist on every users' machine.

My question is - is there a way to include the MSCAL.OCX and any related calendar control files within the workbook itself and have those files automatically installed in the correct folders on the users' machine if they do not already exist? Or am I barking up the wrong tree entirely?

Any help or suggestions you could offer would be greatly appreciated.