Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button - Shrinking Font | Excel Discussion (Misc queries) | |||
Chart series legend font size keeps shrinking - how to stop it? | Charts and Charting in Excel | |||
Shrinking Checkbox and Radio Button | Excel Discussion (Misc queries) | |||
The font of the caption for the commandbutton is illegible. | Excel Discussion (Misc queries) | |||
change caption font color at runtime | Excel Programming |