Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Eddie,
I also had this trouble a while back and found this solution. http://support.microsoft.com/kb/838006/en-us Exit Excel Scroll down to the section "More Information" and follow the 11 steps listed. Relaunch Excel and click away to see if it took. If this doesn't work, you might need a service pack update. Ignore the fact that the article indicates a root cause of screen resolution change. "Eddie" wrote: My "fix" did not hold. I.e., "Deleting the controls, saving and exiting the template, reopening, setting my zoom to 85%, and THEN redefining the controls seems to have worked." I have not had this issue with any other templates. Only difference I can tell is that I have moved from Excel 2002 SP2 to Excel 2003 SP2. Any other thoughts? I can hardly pass this off as professional level quality as it now stands. Thanks. "Eddie" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm - Stop updating the caption after I click on. | Excel Programming | |||
Text box caption=Cell Value (without command click) | Excel Programming | |||
Help with formatting right-click menu caption. | Excel Programming | |||
button caption font shrinking | Excel Programming | |||
Command Button font size increases when clicked | Excel Programming |