Compile error: Can't find project or library - Windows 7 64 bit

Hi all,

I am soooo frustrated with issues running my project on Windows 7 64 bit PCs! The ActiveX controls needed registers on Windows 7 32 bit PCs, but not 64 bit.

So, I have changed my UserForm to make use of a Class Module cCalendar instead of DTPicker, to eliminate issues on the PCs of other users.

BUT, here is my new Windows 7 64 bit issue:

When I run my app, I first get this error:

Could not load some objects because they are not available on this machine

when I then click on OK, I get the following error:

Compile error: Can't find project or library

highlighting the project or library that cannot be found: FirstRowAdd (see attached image). This is part of this section of code:

Private Sub btnSave_Click()
Dim iRow As Long, LR As Long
Dim WS As Worksheet
Set WS = Worksheets("DataSheet - Fitness")

LR = Sheets("DataSheet - Fitness").Range("A" & Rows.Count).End(xlUp).Row
'Find first empty row in database
FirstRowAdd = FirstVisibleValue(ActiveSheet, 1)
If FirstRowAdd = "" Then FirstRowAdd = "$A$" & LR + 1
iRow = Range(FirstRowAdd).Row

'Check for an ID number

If Trim(Me.txtID.Value) = "" Then
  Me.txtID.SetFocus
  MsgBox "Please enter an ID Number"
  Exit Sub
End If

This ONLY happens on Windows 7 64 bit PCs.

I would really appreciate all your help in fixing this issue, as well as making my app compatible with ALL OS!

Thanks!