Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 489
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro button gets bigger when clicked Snowskier Excel Discussion (Misc queries) 1 May 27th 10 09:36 PM
Command Button Gets bigger in size. Sunil Pradhan[_2_] Excel Programming 4 July 10th 09 11:19 AM
Font size smaller and bigger in a formula Gary T Excel Worksheet Functions 1 May 10th 06 04:51 PM
Bug: Command Button Text Size Changes charlie oppenheimer Excel Programming 3 August 22nd 05 12:06 AM
Command Button text changes size RWN Excel Programming 2 May 8th 05 05:38 AM


All times are GMT +1. The time now is 02:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"