I am using Excel 2007 in Windows 7
From the "Developer" ribbon I inserted an ActiveX Spin Button. All seems well and good until I un-click "Design Mode" and use the button. When I click the button it resizes smaller. When it loses focus and I click again, it resizes smaller again. I can fix the resizing (superficially) by clicking "Design Mode" and moving the button anywhere else on the screen. However, now when I click, lose focus, click again, it doesn't resize but the button image distorts as if the button resized smaller and scaled up getting more and more pixelated.
How do I fix this obviously broken behavior? Please help!
Sean.
From the "Developer" ribbon I inserted an ActiveX Spin Button. All seems well and good until I un-click "Design Mode" and use the button. When I click the button it resizes smaller. When it loses focus and I click again, it resizes smaller again. I can fix the resizing (superficially) by clicking "Design Mode" and moving the button anywhere else on the screen. However, now when I click, lose focus, click again, it doesn't resize but the button image distorts as if the button resized smaller and scaled up getting more and more pixelated.
How do I fix this obviously broken behavior? Please help!
Sean.
