I have the simple little code below that works on multiple workbooks that I have.

When I imported the .bas file into my current workbook and tried to use it I get a Microsoft VB - Compile Error; - Can't find project or library.

It stops at LName =

What in the world could I be missing? Like I said it work in other workbooks as it is.


Sub Process_CheckBox()

Dim cBox As CheckBox
Dim LCol As Long
Dim LRow As Long
Dim Rng As Range

  LName = Application.Caller
  Set cBox = ActiveSheet.CheckBoxes(LName)

'Find row that checkbox resides in
  LCol = cBox.TopLeftCell.Column
  LRow = cBox.TopLeftCell.Row
  Set Rng = ActiveSheet.Cells(LRow + 1, LCol + 1)

'Change date in cell to the right of CheckBox, if checkbox is checked
If cBox.Value > 0 Then
  Rng.Value = Date

'Clear date in column B, if checkbox is unchecked
Else
  Rng.ClearContents
End If

End Sub