ActiveX Control Compatibility

[Guest]

I've created a sheet in Excel 2003 with the DTPicker control, but when a user
with either Excel 2000 or 2002 opens it, the controls appear as red Xs. Is
this a compatibility issue or are some components missing on thier
installations?

Thanks in advance.

 

[Chip Pearson]

I believe that the DTPicker is installed as part of Access, so if the target
machine doesn't have Access, it will likely not have the the DTPicker
control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)

 

[Guest]

That makes sense, but is there a method/control to have an excel user have a
date-type picker in excel without access?

 

[Dave Peterson]

Ron de Bruin has a link to a calendar control here:
http://www.rondebruin.nl/calendar.htm

(It's at the bottom of that page.)

 

[Guest]

Awesome.. Thanks!

Ron de Bruin has a link to a calendar control here:
http://www.rondebruin.nl/calendar.htm

(It's at the bottom of that page.)