View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pagates pagates is offline
external usenet poster
 
Posts: 10
Default 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