code won't run
 

I wrote some code in Excel 2003 but I can't get it to run in Excel 2000. The
real problem is that I don't know why. The current line of code is:

MsgBox "Some required information is missing." & Chr$(10) & "Please
ensure all entries are complete." & Chr$(10) & "This file has not been
saved.", vbCritical, "Missing Information"

It gives me an error at the Chr$ part. The error is


Compile Error: Can't find project or library


What is wrong?

code won't run
 

In the VBIDE, go into ToolsReferences, and if there re any items marked as
MISSING, uncheck them.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Keith" wrote in message
...
I wrote some code in Excel 2003 but I can't get it to run in Excel 2000.
The
real problem is that I don't know why. The current line of code is:

MsgBox "Some required information is missing." & Chr$(10) & "Please
ensure all entries are complete." & Chr$(10) & "This file has not been
saved.", vbCritical, "Missing Information"

It gives me an error at the Chr$ part. The error is


Compile Error: Can't find project or library


What is wrong?

code won't run
 

Hi Bob,

That worked a treat. Thanks.

Regards

Keith

"Bob Phillips" wrote:

In the VBIDE, go into ToolsReferences, and if there re any items marked as
MISSING, uncheck them.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Keith" wrote in message
...
I wrote some code in Excel 2003 but I can't get it to run in Excel 2000.
The
real problem is that I don't know why. The current line of code is:

MsgBox "Some required information is missing." & Chr$(10) & "Please
ensure all entries are complete." & Chr$(10) & "This file has not been
saved.", vbCritical, "Missing Information"

It gives me an error at the Chr$ part. The error is


Compile Error: Can't find project or library


What is wrong?