Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default button caption font shrinking

Hi,
I have an interesting problem:
I used the control toolbar to create a command button. then i copied that
button so now i have 2 identical buttons. i changed the caption of one of
these buttons so basically i have one button which has a caption of "on" and
one of "off".
every time i click on one of the buttons, it executes the associated macro
and also the caption text of the button shrinks in size.
the other button when i click it, executes the macro and the text does not
shrink.
in any case the caption of the one button is now unreadably small and i cant
figure out how to get it back to a readible size and stop it from shrinking.
the other button (from which the broken one was cloned) has never had the
problem!
the size of the caption font is not shown in the properties box.

any ideas how to fix this problem?

thanks
Jeff
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default button caption font shrinking

First, I don't have a guess.

But lots of people have complained about using control toolbox toolbar controls
on worksheets and having bad things happen to the formatting properties.

You could see if changing to 100% zoom helps. Or maybe a different video driver
or ????

But you may want to try using buttons from the Forms toolbar. They seem to be
better behaved.



JeffP wrote:

Hi,
I have an interesting problem:
I used the control toolbar to create a command button. then i copied that
button so now i have 2 identical buttons. i changed the caption of one of
these buttons so basically i have one button which has a caption of "on" and
one of "off".
every time i click on one of the buttons, it executes the associated macro
and also the caption text of the button shrinks in size.
the other button when i click it, executes the macro and the text does not
shrink.
in any case the caption of the one button is now unreadably small and i cant
figure out how to get it back to a readible size and stop it from shrinking.
the other button (from which the broken one was cloned) has never had the
problem!
the size of the caption font is not shown in the properties box.

any ideas how to fix this problem?

thanks
Jeff


--

Dave Peterson
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
Command Button - Shrinking Font opieandy Excel Discussion (Misc queries) 2 June 5th 10 12:20 AM
Chart series legend font size keeps shrinking - how to stop it? IanQa Charts and Charting in Excel 0 February 4th 10 08:49 PM
Shrinking Checkbox and Radio Button Dennis C BroadWare Excel Discussion (Misc queries) 0 November 10th 06 03:01 PM
The font of the caption for the commandbutton is illegible. DarkVader Excel Discussion (Misc queries) 2 November 30th 04 02:45 PM
change caption font color at runtime gkelle[_3_] Excel Programming 2 February 5th 04 07:25 PM


All times are GMT +1. The time now is 02:58 PM.

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

About Us

"It's about Microsoft Excel"