Problems with Command Buttons Randomly Resizing themselves

[Blue Aardvark]

I've got a spreadsheet with commandbuttons and comboboxes where these objects
resize themselves for no apparent reason. Sometimes they get bigger or the
font within them grows or shrinks. Has anyone else experienced similar
problems and knows of a solution?

(My current solution is a button that resizes all the buttons.)

Thanks,
Steve

[pianoman]

just to check the simple thing first...!
You're not re-sizing the cells/columns/rows around the buttons are you? If you are, you can go into the button 'format control'/properties and make sure that "don't move or size with cells" is selected...

I've got a spreadsheet with commandbuttons and comboboxes where these objects
resize themselves for no apparent reason. Sometimes they get bigger or the
font within them grows or shrinks. Has anyone else experienced similar
problems and knows of a solution?

(My current solution is a button that resizes all the buttons.)

Thanks,
Steve

[Blue Aardvark]

Nope. Nothing on the sheet changes except the size of the buttons. One thing
I have noticed is that the buttons often like to resize themselves when
clicked upon (and no there isn't any underlying code that alters the object).

[valygrl]

URGENT! I am having this exact same problem, does anyone have a solution?
THANKS!!!

please email me if you do, anna _ levine (remove) @ yahoo dot comm

[Blue Aardvark]

At least I'm not alone! If you want my bit of code that restores the buttons
you can, but it sure doesn't solve the problem.