Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Can't move focus..."
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Can't move focus..."
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Can't move focus..."
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I move a document from "recent items" to "documents" | New Users to Excel | |||
Excel "Move or Copy" and "Delete" sheet functions | Excel Worksheet Functions | |||
Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
Validate Data in VBA "How to get lost focus cell address" | Excel Programming |