I just got a new computer that has Excel 2010. I have always used Excel 2003 at work and all previous home computers.
When I open the workbook it usually opens a userform but in 2010, I get:
could not load an object because it is not available on this machine
Then the userform loads, when I try to hit the command button on the userform I get:
compile error :cant find project or library (when I hit debug it highlights chr(10) in the code)
I went to the references section and I see:
MISSING: Microsoft Calendar Control 11.0
MISSING: Microsoft Windows Common Controls-2 6.0 (SP4)
MISSING: Microsoft Outlook 12.0 Object Library
I tried looking for these and cannot locate them.
Is there anyway to have 2010 default to 2003 or is there a way around this?
Thanks for any help.
JJ
Bookmarks