ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Error 459 on callup of UserForm with ActiveX control (https://www.excelbanter.com/excel-programming/359186-error-459-callup-userform-activex-control.html)

pagates

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

Peter T

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




pagates

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






All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com