I posted this over an old post but did not get any reply so I will post it
into a new post... this is what I have post and where I get teh info... some
I can get some help before doing what is proposal. Thanks.

Please read below post from bottom post to top... it is not much...

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,

"Jim Thomlinson" wrote:

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

Untick the reference in your original file and see what happens - you can
always go back and tick it again!

Sam


"Alberto Ast" wrote:

I posted this over an old post but did not get any reply so I will post it
into a new post... this is what I have post and where I get teh info... some
I can get some help before doing what is proposal. Thanks.

Please read below post from bottom post to top... it is not much...

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,

"Jim Thomlinson" wrote:

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