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
To 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.
I then reran the module, and it worked without a problem!