When I click buttons I have added the font or button resize, Why?
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? |
When I click buttons I have added the font or button resize, Why?
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. Chris wrote: 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? -- Dave Peterson |
When I click buttons I have added the font or button resize, Why?
"Chris" wrote: 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 |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com