Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 459 on callup of UserForm with ActiveX control
Hello All,
We have an Add-In that uses a VB6 ActiveX control on a UserForm. The UserForm is simply called up from a toolbar macro saying "MyForm.Show". The ActiveX control sits on a Multipage control, inside another Multipage control. Recently, we have started to get an error on deployed versions of our Add-In: "Run-time Error 459: Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus." This control and mechanism has worked fine in the past. The part that puzzles/frustrates me the most, I guess, is that if I get on the machine, and manually remove and re-add the control on the form in the Add-In, it works fine. AAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGHHHHH HHHHHH!!!! Any help would likely lengthen my sanity for a few more minutes, and I guess that would be appreciated. Thanks, PAGates |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 459 on callup of UserForm with ActiveX control
Might be worth checking that the respective versions of the ActiveX are
same. Regards, Peter T "pagates" wrote in message ... Hello All, We have an Add-In that uses a VB6 ActiveX control on a UserForm. The UserForm is simply called up from a toolbar macro saying "MyForm.Show". The ActiveX control sits on a Multipage control, inside another Multipage control. Recently, we have started to get an error on deployed versions of our Add-In: "Run-time Error 459: Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus." This control and mechanism has worked fine in the past. The part that puzzles/frustrates me the most, I guess, is that if I get on the machine, and manually remove and re-add the control on the form in the Add-In, it works fine. AAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGHHHHH HHHHHH!!!! Any help would likely lengthen my sanity for a few more minutes, and I guess that would be appreciated. Thanks, PAGates |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error 459 on callup of UserForm with ActiveX control
Hi Peter,
Yes, they are the same. I guess I didn't explain clearly enough. I simply open the VBA project on the client machine, open the form, delete the existing control, add it to the toolbox, and add it to the form. I don't download a new version of the control. Thanks, PAGates "Peter T" wrote: Might be worth checking that the respective versions of the ActiveX are same. Regards, Peter T "pagates" wrote in message ... Hello All, We have an Add-In that uses a VB6 ActiveX control on a UserForm. The UserForm is simply called up from a toolbar macro saying "MyForm.Show". The ActiveX control sits on a Multipage control, inside another Multipage control. Recently, we have started to get an error on deployed versions of our Add-In: "Run-time Error 459: Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus." This control and mechanism has worked fine in the past. The part that puzzles/frustrates me the most, I guess, is that if I get on the machine, and manually remove and re-add the control on the form in the Add-In, it works fine. AAAAAAAAAAAAAARRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGHHHHH HHHHHH!!!! Any help would likely lengthen my sanity for a few more minutes, and I guess that would be appreciated. Thanks, PAGates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
ActiveX control error - | Excel Programming | |||
Userform Control Error | Excel Programming | |||
Error 50290: Error writing to Worksheet while using an ActiveX Control | Excel Programming | |||
ActiveX Error w/Calendar Control | Excel Programming |