Solved: Error With Code (Compile Error) ~Excel 97~

[phendrena]

Hi,

I'm been advised that one of my users is getting an error however, all other users don't appear to have any problems.

[vba]If Trim(Me.cboCanxType.Value) = "" Then
Me.cboCanxType.SetFocus
MsgBox "Is this a Mid-Term or Renewal Cancellation?"
Exit Sub
End If[/vba]

The above code is called as part of the update routine.
When this users clicks the update button they get the following error :-

"Compile Error:
Can't find project or library"

The workbook isn't a shared document and is open as read-only but multiple users.

Any suggestions why this is occuring?

Thanks,

[Bob Phillips]

On that users machine, in te VBIDE, goto menu Tools>References.

You will find an item with MISSING in it's text, uncheck that item.

[phendrena]

Thats great, thanks xld