Jon

I tried that and it let me add the "real" refedit control but when I
clicked OK it said "Name conflicts with existing module, project or
object library" and I still can't untick the offending one.

John

On Wed, 28 May 2008 21:07:51 -0400, "Jon Peltier"
wrote:

Hmm, Excel 2000 through 2007 let you uncheck the RefEdit reference. You get
the problem even if it says "Missing:"?

Let's try something equally desperate. How about browsing to the "real"
RefEdit on the computer in question, and checking its box. I'm hoping that
this will let you remove the broken reference.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John A" wrote in message
.. .
If I try to uncheck it, it says "Can't remove control or reference; in
use"

On Wed, 28 May 2008 08:17:24 -0400, "Jon Peltier"
wrote:

Uncheck the reference and save the file. (Isn't always sufficient to fix
the
problem.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"John A" wrote in message
...
Thanks Gary

Yes Missing is Ref Edit Control. I see that on computers C & D it is
looking for Ref Edit Control in c:\program files\microsoft
office\office12, which doesn't exist, but does exist on computers A &
B because Publisher 2007 is installed on those. Refedit.twd and
refedit.dll are in the system32 folder on systems C & D.

How would I fix that?

John

On Wed, 28 May 2008 02:48:50 -0400, "Gary Keramidas"
<GKeramidasATmsn.com wrote:

haven't used 97 in ages so this may be wrong. but in vb, click tools and
then
references and see if any are tagged as missing. someone more familiar
with 97
may chime in.