When I click buttons I have added the font or button resize, Why?

G

Guest

I have some buttons on my spreadsheet that I use to execute some commands.
When I click them they will resize. The font resizes smaller each time until
I can't even read it. Sometimes the button itself will resize and get bigger
with each click. If I resize the button in design mode the font goes back to
normal. Why is this happening?
 
D

Dave Peterson

I've never seen this in real life, but I have read posts that describe this
problem when using controls from the control toolbox toolbar.

Any chance you could use the buttons from the Forms toolbar.

You'll have to move the code to a general module (and maybe rewrite some of it),
so you may want to experiment with a couple of buttons before you do all of
them.
 
G

Guest

Chris said:
I have some buttons on my spreadsheet that I use to execute some commands.
When I click them they will resize. The font resizes smaller each time until
I can't even read it. Sometimes the button itself will resize and get bigger
with each click. If I resize the button in design mode the font goes back to
normal. Why is this happening?

Right Click on the button and choose Format control. Click on the properties
Tab and click on the Don't resize object with cells.

Peter Atherton
 

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

Top