Re: Command Button text changes size

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.
--
Regards;
Rob
------------------------------------------------------------------------
"Davie" <spam@xxxxxxxxxxxxx> wrote in message news:d5ilkl$sps$1@xxxxxxxxxxxxxxxxxxxxxx
> 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 work*** 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 wrote in message <#39M#9STFHA.2548@xxxxxxxxxxxxxxxxxxxx>...
> >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.
> >
> >
> >--
> >Regards;
> >Rob
> >------------------------------------------------------------------------
> >
> >
>
>


.