Deleting the controls, saving and exiting the template, reopening, setting
my zoom to 85%, and THEN redefining the controls seems to have worked. I do
like easy answers. Thanks.
"Eddie" wrote in message
...
Tom, that describes the problen exactly. But I have always set my zoom at
85% in my apps, and I have never seen this behavior before. Still, very
much appreciate the reference. Now probably just need to play with a bit
and see if I can get around. I think I'll delete my exisitng controls,
save, reopen, and redefine. And see what happens. Thanks.
"Tom Ogilvy" wrote in message
...
I found an article that related this to the zoom setting on the sheet
being
less than 100%. It was for Excel 2000, so may not be pertinent.
http://support.microsoft.com/kb/211866/en-us
--
Regards,
Tom Ogilvy
"Eddie" wrote:
Working in Excel 2003 SP2, I have three command buttons which, when
clicked,
will have their displayed captions increase in size -- getting larger on
each run.
1. When I go into VBA properties for the command button, the font
setting
is unchanged.
2. Furthermore, getting the VBA font property to reset the display
doesn't
seem to work well. It's as though it associates the current displayed
font
(call 76, maybe) with the current properties font (say 12). So changing
the
property font from 12 to 10, say, still displays as big. And once you
have
reset to the smallest font available, you are basically stuck.
I haven't a clue and have not seen this before. Autosize is off, as is
TakeFocusOnClick.
Thanks in advance. Larry.