Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen resolution kernel call
I have three different video screens. Each set to 1024x768
but the points or pitch of the screens are .31, .24 & .22. So a 'Sheet' displaying at 100% on a .24 screen requires a 75% reduction on a .31 screen. An .22 screen, the hyperlink 'cell' does not show in the same area as the other two screens. I need code to determine screen resolution (kernel call) and can I determine the screen point or pitch. Is there a formula that can position the same info on multiple different screens point/pitch? TIA Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen resolution kernel call
Hi Tom,
why do you not zoom in an auto_open macro (event)? If you want to display colums a to k then you could use: Range("A6:K6").Select ActiveWindow.Zoom = True regards arno "Tom Rudski" schrieb im Newsbeitrag ... I have three different video screens. Each set to 1024x768 but the points or pitch of the screens are .31, .24 & .22. So a 'Sheet' displaying at 100% on a .24 screen requires a 75% reduction on a .31 screen. An .22 screen, the hyperlink 'cell' does not show in the same area as the other two screens. I need code to determine screen resolution (kernel call) and can I determine the screen point or pitch. Is there a formula that can position the same info on multiple different screens point/pitch? TIA Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable screen size, not resolution | Excel Worksheet Functions | |||
Screen resolution | Excel Programming | |||
Can the screen resolution be changed within VBA? | Excel Programming | |||
Screen Area Resolution | Excel Programming | |||
Excel screen resolution query | Excel Programming |