Compile Error in Hidden Module: Module 1

[Mim]

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

 

[Jim Thomlinson]

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...

 

[Alberto Ast]

I have same problem.... I try some of it and looks like it works but before I
save the change i would like to ask some questions...

The missing library is "MISSING: Ref. Edit. Control" which I can uncheck and
will work... but this is with the file I get mailed from another PC... my
original file does show this as OK... if I uncheck it might help me make the
file work when I get it back by mail...

But how will this affect my original program if I uncheck "Ref. Edit.
Control" from my original file...?

Thanks,