ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   button text size gets bigger (https://www.excelbanter.com/excel-programming/439900-button-text-size-gets-bigger.html)

Matt S

button text size gets bigger
 
Hi,

I placed a button on my excel sheet to run a macro. Problem is, every time
I click on it, the text gets larger. Eventually, I can't even read what it
says.

Thanks for any help,
Matt

Ryan H

button text size gets bigger
 
Are you inserting or resizing cell or rows where the button is. Right click
the button, select Format Control, click Properties, click "Don't Move or
Size with Cells"

Hope this helps! If so, let me know click "YES" below.
--
Cheers,
Ryan


"Matt S" wrote:

Hi,

I placed a button on my excel sheet to run a macro. Problem is, every time
I click on it, the text gets larger. Eventually, I can't even read what it
says.

Thanks for any help,
Matt


Matt S

button text size gets bigger
 
I am not changing any cells near the button. And the weird thing is, the
text is listed at size 8. To undo the size change, I have to click on
'auto-size' then resize the button and change the font again.

Matt


"Ryan H" wrote:

Are you inserting or resizing cell or rows where the button is. Right click
the button, select Format Control, click Properties, click "Don't Move or
Size with Cells"

Hope this helps! If so, let me know click "YES" below.
--
Cheers,
Ryan


"Matt S" wrote:

Hi,

I placed a button on my excel sheet to run a macro. Problem is, every time
I click on it, the text gets larger. Eventually, I can't even read what it
says.

Thanks for any help,
Matt


Brent[_10_]

button text size gets bigger
 
On Feb 23, 10:29*pm, Matt S wrote:
I am not changing any cells near thebutton. *And the weird thing is, thetextis listed atsize8. *To undo thesizechange, I have to click on
'auto-size' then resize thebuttonand change the font again.

Matt

"Ryan H" wrote:
Are you inserting or resizing cell or rows where thebuttonis. *Right click
thebutton, select Format Control, click Properties, click "Don't Move or
Sizewith Cells"


Hope this helps! *If so, let me know click "YES" below.
--
Cheers,
Ryan


"Matt S" wrote:


Hi,


I placed abuttonon my excel sheet to run a macro. *Problem is, every time
I click on it, thetextgets larger. *Eventually, I can't even read what it
says.


Thanks for any help,
Matt


I have this same problem. Has anyone found a solution?

Brent



All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com