I have a program that uses the *Microsoft Date and Time Picker* to
select a date. When I put my macro on another users computer I get an
error message that says: "-Can't move focus to the control because it
is invisible, not enabled, or of a type that does not acept the
focus-."

If I go to look at the userform, it does not have the drop down
calendars (DT Picker) that I put on it.
It works fine from my computer, but I can't find what's different about
the other computer not to accept the DT Picker.

Any ideas??

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=472172

The problematic computer probably doesn't have the Microsoft Date and Time
Picker installed or your reference to it is invalid.

On that computer, after the error, go to Tools=References in the VBE and
see if you don't see a reference marked as MISSING - specifically the
reference to the Microsoft Date and Time Picker.

--
Regards,
Tom Ogilvy

"DejaVu" wrote in
message ...

I have a program that uses the *Microsoft Date and Time Picker* to
select a date. When I put my macro on another users computer I get an
error message that says: "-Can't move focus to the control because it
is invisible, not enabled, or of a type that does not acept the
focus-."

If I go to look at the userform, it does not have the drop down
calendars (DT Picker) that I put on it.
It works fine from my computer, but I can't find what's different about
the other computer not to accept the DT Picker.

Any ideas??

DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile:
http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=472172

Thanks for the reply Tom - But I'm still not having any luck.

Here is what I tried. I opened up the form from my computer (where th
DTPicker works) and opened up Tools Additional Controls.
In Additional Controls I found *Microsoft Date and Time Picker Contro
6.0* and noticed it comes from -C:\\WINNT\system32\mscomct2.ocx
(Windows 2000).
I copied this ActiveX control to the other users computer, but I stil
can not add the DTPicker control.

Any other ideas?

DejaV

--
DejaV
-----------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...fo&userid=2262
View this thread: http://www.excelforum.com/showthread.php?threadid=47217