Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preset Display Setting in Auto Open
I don't think you can do it though anything other than Windows AP
functions, and I'm not sure you really want to be changing the user' display settings. If they have a high resolution and have a ton o shortcuts, it will squish them all together (that's what happens on m machine as I am running 1600x1200). My approach has always been to develop my spreadsheets in the most use resolution (800x600) and anyone with 640x480 would be asked to chang their resolution. Much the same as on some websites that suggest best screen resolution. Another less friendly option is to change the zoom so that it will fi on the screen (regardless of resolution). Something like: Range("A1:G16").Select ActiveWindow.Zoom = True Range("A1").Select -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open worksheet with preset columns displayed? | New Users to Excel | |||
Setting Y axis display labels | Charts and Charting in Excel | |||
How do I preset data to auto copy to a certain page | Excel Discussion (Misc queries) | |||
How can I set up the default setting of a chart display? | Setting up and Configuration of Excel | |||
Preset Display Setting in Auto Open | Excel Programming |