Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing windows automatically
I am writing an Excel program to distribute to my clients
in the water biz. I'd like to know if I need to include code to adjust screen or window sizes to account for each user's display settings. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sizing windows automatically
Maybe you can just set the zoom factor to fit your data nicely.
Application.Goto Worksheets("sheet1").Range("A8:AG8"), scroll:=True ActiveWindow.Zoom = True I like to include one extra skinny column at the right. Sometimes it makes it look nicer. tom Troyer wrote: I am writing an Excel program to distribute to my clients in the water biz. I'd like to know if I need to include code to adjust screen or window sizes to account for each user's display settings. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
When I open a document it automatically opens up in 2 windows. | Excel Discussion (Misc queries) | |||
Automatically re-sizing merged cells | Excel Worksheet Functions | |||
automatically sizing text with graphs | Charts and Charting in Excel | |||
Prevent open excel windows from automatically closing. | Excel Discussion (Misc queries) |