Hi jonvanwyk
The error you're receiving usually indicates a missing reference. I'd guess it's the Calendar Control as it's not included with Excel 2010. On the offending machine in VBA go to Tools ----> References and see if any are missing. If it is the Calendar Control you can download it from several sites. You may wish to explore options to Calendar Control...there are several good ones available.