Microsoft Calendar Control 11.0 in Excel 2007

I recently had a problem whereby I had written some code in Excel 2003 but when it was ported over to Excel 2007 and then run it produced the following error message:

compile error: cant find project or library

reference-vbeTo fix this problem I went into the VBE (Visual Basic Environment) and clicked on Tools/References and unclicked the Calendar Control 11.0.  Within the References box it was showing the calendar control as MISSING.  I believe Microsoft Excel 2007 has this built in at v.12.

reference-box

I then reran the module, and it worked without a problem!

Leave a Reply

Your email address will not be published. Required fields are marked *