I recently distributed a 2007 workbook that contained pop up calendars
courtesy of the Microsoft Office Calendar Control 2007. I foolishly assumed
that when a user opened the workbook, Excel would €œrealise€� that there was a
Calendar control embedded and automatically enable the VB reference.
Optimistic eh?
I was looking at ways to automate the enablement of the Calendar reference
object €“ I found this code on Chip Pearsons site and wondered if a similar
thing could be run to automatically select the Calendar control? This code
enables the Microsoft Visual Basic Application Extensibility 5.3 object
library.

ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{0002E157-0000-0000-C000-000000000046}", _
Major:=5, Minor:=3

All help appreciated!
Kind regards,
Robert


Rodels! Creating weapons of Maths Destruction since 2003.