Command Button Font Changes Size

  • Thread starter Thread starter Tom Grillot
  • Start date Start date
T

Tom Grillot

I have a command button on a worksheet that calls a function. The function
simply navigates to a specified cell. After I click the button the button
caption's font gets smaller and the button stays "depressed." I created a
test button that just opens a message box and it does the same thing.

If I go to design mode and resize the button the font restores itself to the
original size.

I've done a lot of VBA programming, but I've never messed around with Excel
forms and controls. What have I overlooked?

Thanks,
Tom
 
I've never seen this in real life, but this problem shows up in the newsgroup
every so often.

I'd replace the commandbutton from the control toolbox toolbar with a button
from the Forms toolbar. You'll have to move the code and maybe modify it. But
those buttons from the Forms toolbar seem to behave nicer.

Or I'd delete that commandbutton and replace it with another commandbutton (from
the same control toolbox toolbar). Just to see if that helped.
 
Thanks, that did it!

Tom


Dave Peterson said:
I've never seen this in real life, but this problem shows up in the
newsgroup
every so often.

I'd replace the commandbutton from the control toolbox toolbar with a
button
from the Forms toolbar. You'll have to move the code and maybe modify it.
But
those buttons from the Forms toolbar seem to behave nicer.

Or I'd delete that commandbutton and replace it with another commandbutton
(from
the same control toolbox toolbar). Just to see if that helped.
Click to expand...
 
Back
Top