ActiveX Control Compatibility
 

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.

ActiveX Control Compatibility
 

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)

"Racer49" wrote in message
...
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.

ActiveX Control Compatibility
 

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

"Chip Pearson" wrote:

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)

"Racer49" wrote in message
...
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.

ActiveX Control Compatibility
 

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

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

Racer49 wrote:

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

"Chip Pearson" wrote:

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)

"Racer49" wrote in message
...
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.




--

Dave Peterson

ActiveX Control Compatibility
 

Awesome.. Thanks!

"Dave Peterson" wrote:

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

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

Racer49 wrote:

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

"Chip Pearson" wrote:

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)

"Racer49" wrote in message
...
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.




--

Dave Peterson