View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
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