Compile Error: Strange happening
 

An Excel app written using 2002 worked fine (at first) when loaded to a
network and tested on PC's using 2002.

But a PC with 2003 returned a "Compile Error: Can't find project or
library." Then when going back to the 2002 PC's, I get the same compile
error.

Can anyone help me with this?

Also, the test on the PC with 2003 caused the name of a named range to
disappear.

Strange happenings.

Thank you for your assistance.
--
Don

Compile Error: Strange happening
 

On the problematic PC, go to the VBA Editor, Tools menu,
References. Look for any marked 'MISSING' and, if possible,
remove them.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Don Rouse" wrote in message
...
An Excel app written using 2002 worked fine (at first) when
loaded to a
network and tested on PC's using 2002.

But a PC with 2003 returned a "Compile Error: Can't find
project or
library." Then when going back to the 2002 PC's, I get the
same compile
error.

Can anyone help me with this?

Also, the test on the PC with 2003 caused the name of a named
range to
disappear.

Strange happenings.

Thank you for your assistance.
--
Don

Compile Error: Strange happening
 

Thank you, Chip.
--
Don


"Chip Pearson" wrote:

On the problematic PC, go to the VBA Editor, Tools menu,
References. Look for any marked 'MISSING' and, if possible,
remove them.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Don Rouse" wrote in message
...
An Excel app written using 2002 worked fine (at first) when
loaded to a
network and tested on PC's using 2002.

But a PC with 2003 returned a "Compile Error: Can't find
project or
library." Then when going back to the 2002 PC's, I get the
same compile
error.

Can anyone help me with this?

Also, the test on the PC with 2003 caused the name of a named
range to
disappear.

Strange happenings.

Thank you for your assistance.
--
Don