button text size gets bigger

  • Follow


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
0
Reply Utf 2/24/2010 1:48:10 AM

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
0
Reply Utf 2/24/2010 2:01:01 AM


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
0
Reply Utf 2/24/2010 2:29:01 AM

2 Replies
1144 Views

(page loaded in 0.023 seconds)


Reply: