strange behavior by ActiveX controls
Yes, the ActiveX controls I described are in a worksheet in Excel 2002.
After experiencing this, I too am going to use Forms controls whenever
possible.
I wonder what's up with Microsoft - if this type of thing reared its head in
Excel 97, they must have known about it, and it's surprising they still
haven't fixed it two major upgrades later.
"Tim Zych" wrote in message
...
Is this being used on a worksheet?
The only time I saw this bug was while using XL97. I think the way I fixed
it was to recreate the button and make it a bit larger/smaller until it no
longer happened.
ActiveX controls on worksheets can be finicky. I try to avoid using them
wherever possible and use Forms controls instead.
"Paul James" wrote in message
...
I'll also mention that there's nothing in the code that's being run in
the
click event of these controls that affects the ActiveX objects
themselves.
That is, I'm not resetting any of the properties of the controls, or
moving
or resizing any ranges in the sheets where the controls reside. The
code
simply copies data from one place in the worksheet to another place. So
I
don't think the code that's being run is causing the bizzare behavior
I've
described.
|