Hmm, no, that wasn't it. I got the error in 2007 when I opened the workbook.
On the computer on which I created the workbook, the dll is in

"c:\program files\microsoft office 2007\office 12\"

but on this computer (actually a virtual machine on this computer), Office
2007 is installed in

"c:\program files\microsoft office\office 12\"

I've never had this issue with a nonstandard installation directory before,
and I'm a bit surprised it came up here.

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


"Jon Peltier" wrote in message
...
I had a problem yesterday with some userforms with RefEdits. I'd built the
forms in Excel 2007, probably SP1, but I converted the file to Excel 2003,
and opened it in Excel 2003 SP2 (not SP3), and the RefEdits on the
UserForms were gone. I added a RefEdit to one form, then thought I should
check the references. I had one working reference to RefEdit.dll
(presumably the one I just added), and one MISSING reference to RefEdit.dll
(presumably the broken one).

So I wonder if 2007 SP1 has the same effect as 2003 SP3? I was just going
to ignore this, or attribute it to trying to backsave the workbook, but
maybe that's not the issue.

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


"Bob Flanagan" wrote in message
. ..
Shortly after installing SP3 in Excel 2003, I created a new workbook with
a refedit control on a dialog. At least, I tried to. I got an error
message when I tried to add the refedit control. So I did a repair of
Office. I was able to add the control then. However, when I check Tools,
References, I have a reference to a refedit.dll. And I have to remove it
in order to share the files with others. Otherwise, they get an error in
module 1 message. The refedit control works fine after the reference is
removed.

Any ideas on how to make the addition of the refedit control work
properly and not add in that reference?

Bob