Compile error since upgrading to 2003

[seacrest]

I am experiencing a strange problem with a date picker macro that i use on many workbooks since upgrading to 2003
I get a Compile error: Variable not defined


However I can create a new workbook with the same code and it works fine
Here is the code

Option Explicit

' ===================================================
' Code by Martin Green eMail martin@fontstuff.com
' Visit my Office Tips web site at www.fontstuff.com
' ===================================================

Private Sub cmdClose_Click()
' Close the UserForm
Unload Me
End Sub

Private Sub UserForm_Initialize()
' Check if active cell contains a date. If 'yes' show
' same date on calendar. If 'no' show today's date.
If IsDate(ActiveCell.Value) Then
Calendar1.Value = DateValue(ActiveCell.Value)
Else
Calendar1.Value = Date
End If
End Sub

Private Sub Calendar1_Click()
' Transfer date selected on calendar to active cell
' and close UserForm.
ActiveCell.Value = Calendar1.Value
Unload Me
End Sub

 

[jkpieterse]

Either the calendar control is not installed on your system (it is part of Office professional, I think it "belongs" to Access), or you have to add a reference to it in your VBA project.

 

[seacrest]

My new workbook has a reference Microsoft Calendar Control 11.0
but the old workbook doesn't.
Any ideas on how to add too the old


Thanks,

 

[jkpieterse]

I think your easiest solution is to delete the calendar control from the userform and add it again.

 

[seacrest]

That diddn't work and struggling to understand why it would

 

[jkpieterse]

Can you attach the workbook (removing any sensitive information, but still showing the problem)