Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button text changes size
I have a template with some buttons and if the user changes the screen resolution, opens
the template and hits the button the text will change size. In other cases a right click on the button will cause the button to expand in size. Bottom line is that it goes "wonky" depending on when the user changes the resolution and opens the template. We've never had the problem before because the resolution was never changed (800 x 600). A new system requires us to flip it to 1024x768 when using the app (this is too small for us "older" users which results in changing it, depending on the task at hand). Is there any way to "lock" the Command Buttons to ensure that they remain in proportion to the current screen resolution? This happens in both xl2k/w2k and xl03/xp. -- Regards; Rob ------------------------------------------------------------------------ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button text changes size
I've had problems with screen resolutions and although I haven't tried this
out with your exact problem this is what I have done previously. As I know how many columns I want to be visible I add a command so that when a worksheet is displayed a range from column A to the last column is selected and then the line of code ActiveWindow.Zoom = True is inserted. This changes the magnification of the screen so that the resolution is not a problem. As I said I haven't tried this with your problem. RWN wrote in message ... I have a template with some buttons and if the user changes the screen resolution, opens the template and hits the button the text will change size. In other cases a right click on the button will cause the button to expand in size. Bottom line is that it goes "wonky" depending on when the user changes the resolution and opens the template. We've never had the problem before because the resolution was never changed (800 x 600). A new system requires us to flip it to 1024x768 when using the app (this is too small for us "older" users which results in changing it, depending on the task at hand). Is there any way to "lock" the Command Buttons to ensure that they remain in proportion to the current screen resolution? This happens in both xl2k/w2k and xl03/xp. -- Regards; Rob ------------------------------------------------------------------------ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Button text changes size
Davie;
Thanks for the reply. Because it had been awhile I posted the same query on the Misc ng (May 3/05) and Dave Peterson replied with; <quote "Not a solution--in fact, not even a guess... Have you thought about replacing the commandbuttons from the control toolbox toolbar with buttons from the Forms toolbar? I've seen a few posts that say that the Forms controls are better behaved on worksheets (than the controls from the control toolbox toolbar)." <endquote) Turns out that only the Command Buttons are affected-which is fortunate for me-because the majority of the templates I have in production use the button from the control toolbox. I also found that if I closed Excel, before changing the resolution (which is a PITA!), all was well . Again, thanks for your time. -- Regards; Rob ------------------------------------------------------------------------ "Davie" wrote in message ... I've had problems with screen resolutions and although I haven't tried this out with your exact problem this is what I have done previously. As I know how many columns I want to be visible I add a command so that when a worksheet is displayed a range from column A to the last column is selected and then the line of code ActiveWindow.Zoom = True is inserted. This changes the magnification of the screen so that the resolution is not a problem. As I said I haven't tried this with your problem. RWN wrote in message ... I have a template with some buttons and if the user changes the screen resolution, opens the template and hits the button the text will change size. In other cases a right click on the button will cause the button to expand in size. Bottom line is that it goes "wonky" depending on when the user changes the resolution and opens the template. We've never had the problem before because the resolution was never changed (800 x 600). A new system requires us to flip it to 1024x768 when using the app (this is too small for us "older" users which results in changing it, depending on the task at hand). Is there any way to "lock" the Command Buttons to ensure that they remain in proportion to the current screen resolution? This happens in both xl2k/w2k and xl03/xp. -- Regards; Rob ------------------------------------------------------------------------ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command button font size changes | Excel Discussion (Misc queries) | |||
Command button text | Excel Discussion (Misc queries) | |||
Font Size in Command Button | Excel Discussion (Misc queries) | |||
Command Button font size increases when clicked | Excel Programming | |||
Locking command button size to cell proportions? | Excel Programming |