Command Button text changes size

[RWN]

I have a template with some buttons and if the user changes the screen resolution, opens
the template and hits the button the text will change size. In other cases a right click
on the button will cause the button to expand in size.
Bottom line is that it goes "wonky" depending on when the user changes the resolution and
opens the template.

We've never had the problem before because the resolution was never changed (800 x 600). A
new system requires us to flip it to 1024x768 when using the app (this is too small for us
"older" users which results in changing it, depending on the task at hand).

Is there any way to "lock" the Command Buttons to ensure that they remain in proportion to
the current screen resolution?

This happens in both xl2k/w2k and xl03/xp.

 

[Davie]

I've had problems with screen resolutions and although I haven't tried this
out with your exact problem this is what I have done previously.

As I know how many columns I want to be visible I add a command so that when
a worksheet is displayed a range from column A to the last column is
selected and then the line of code

ActiveWindow.Zoom = True

is inserted. This changes the magnification of the screen so that the
resolution is not a problem. As I said I haven't tried this with your
problem.

 

[RWN]

Davie;
Thanks for the reply.
Because it had been awhile I posted the same query on the Misc ng (May 3/05) and Dave
Peterson replied with;
<quote>
"Not a solution--in fact, not even a guess...
Have you thought about replacing the commandbuttons from the control toolbox
toolbar with buttons from the Forms toolbar?
I've seen a few posts that say that the Forms controls are better behaved on
worksheets (than the controls from the control toolbox toolbar)."
<endquote)

Turns out that only the Command Buttons are affected-which is fortunate for me-because the
majority of the templates I have in production use the button from the control toolbox.

I also found that if I closed Excel, before changing the resolution (which is a PITA!),
all was well .

Again, thanks for your time.