Option Button on sheet changes size in 1024 by 768 resolution
Hello Michael:
I have experienced this exact problem since acquiring a new computer
with Excel 2003 in January of this year, and it is a very serious
problem. It affects other controls (option buttons, checkboxes, etc.)
as well as the command button. If you use a button from the Forms
Toolbar, you will not have this problem. However, the functionality
and feature-set available to you is not as extensive with a Forms
button. It can activate a macro, though, and this might be all you
want to do. One problem with the button from the Forms toolbar is that
it doesn't give a good "snap action" when clicked (at least not on my
high-end laptop which is running Excel 2003).
This "controls" problem (changing size, wild behavior of fonts) has -
in my opinion - essentially disabled the use of ActiveX controls in
Excel, which I think should be regarded as a MAJOR, MAJOR problem
worthy of no-holds-barred attention of Microsoft. I know 5 other
people with the same problem, and all have different machines with MS
Office acquired independantly. It is related to the screen resolution
issue. If you create an application with 1024x768 setting - and if you
never change it - I believe things work fine. But the world is moving
to widescreen laptops, and users want their screens set to the wide
format. But doing so with Excel will cripple advanced programs using
ActiveX controls.
If you should learn of a fix - tomorrow or next year - would you kindly
let me in on it!
Regards
David
|