Problems with Command Buttons Randomly Resizing themselves

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
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).
 
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
 
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.
 
Someone I have provided a spreadsheet that I created is having this same
issue. Did anyone ever find a solution or at least a cause?
 
No one has come forward with any solution/causes. It seems to be somehow
linked to the users machine as I rarely get the problem on my machine, but
other users are cursed by this issue on a daily basis.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Command Buttons on Excel Worksheet - font size decreases on click 4
Command buttons duplicating themselves 2
Command Button & Font Size 4
Command Button - Shrinking Font 1
Shrinking buttons 7
When I click buttons I have added the font or button resize, Why? 2
URGENT help needed for a macro to place and size command button 7
Command button moves even with don't move or resize checked. 4

Back
Top