View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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