Bring up the VBE (Alt + F11). Select Tools - References and look for a
reference that starts with "Missing:". You may be able to just uncheck the
reference depending what it is. Once you have unchecked the reference select
Debug - Compile and see if the project compiles. If it does not then you
will need to select an appropriate refrence. The only reference that springs
to mind if "Microsoft ActiveX Data objects RecordSet 2.7" which I believe
was upgraded to 2.8 is SP3...
--
HTH...

Jim Thomlinson


"Mim" wrote:

I have a workbook that has code that works on my computer, and a couple of
other computers. However, when the workbook is emailed to someone, then
emailed back, I get the compile error above. I originally had the code
password protected, but have since removed the password thinking that could
be the problem - but that didn't work.
the one thing I did notice was that the computer to which the file was sent
has Windows SP3 installed, while the computer getting the error on return has
SP2 installed. Could this have anything to do with it?
Does anyone know to what "Hidden Module" refers to if the code is not
password protected?
Thanks