PDA

View Full Version : Solved: Error With Code (Compile Error) ~Excel 97~



phendrena
01-16-2009, 08:08 AM
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.

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

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
01-16-2009, 08:21 AM
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
01-20-2009, 09:17 AM
Thats great, thanks xld :)