Activate an activex control on a sheet in excel 97?
 

Using Excel 2003 you can place the following code into the keydown event of
an activex control and it works, but it produces an error message in excel 97.

me.oleobjects("CheckBox2").activate

Any help with this would be very much appreciated.

Thanks!

Activate an activex control on a sheet in excel 97?
 

I assume you are running that code from the click event of another ActiveX,
or while another ActiveX has focus. In XL97 you would need to deselect
before trying to select another, or indeed before doing many other things
come to that. If you REALLY need to activate your checkbox try preceding
with:

Activecell.activate
me.oleobjects("CheckBox2").activate

Be aware that controls that have focus lead to all sorts of problems in
XL97, not only the problem you've encountered.

Regards,
Peter T

"VLONC7109" wrote in message
...
Using Excel 2003 you can place the following code into the keydown event
of
an activex control and it works, but it produces an error message in excel
97.

me.oleobjects("CheckBox2").activate

Any help with this would be very much appreciated.

Thanks!