Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center application window
Hi
Trying to center the Excel application. Screen resalution is 1280 x 1024 newWidth is a long and set to 800 newHeight is a long and set to 600 maxWidth is a long and set to 1280 maxHeight is a long and set to 1024 The following code moves the to far left and to far from the top. Application.WindowState = xlNormal Application.Width = newWidth Application.Height = newHeight Application.Left = (maxWidth - newWidth) / 2 Application.Top = (maxHeight - newHeight) / 2 Thanks Harold |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center application window
The screen res' is measured in pixels but the application dimensions are in
points. In most systems to convert it's typically 96 pixels per 72 points. Simplest way to correct your routine is probably just to do this - newWidth = 800 * 0.75 newHeight = 600 * 0.75 maxWidth = 1024 * 0.75 maxHeight = 768 * 0.75 If you are distributing to unknown users best to get the screen res and "points to pixels" using APIs. Regards, Peter T |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Center application window
"Peter T" wrote in message ... The screen res' is measured in pixels but the application dimensions are in points. In most systems to convert it's typically 96 pixels per 72 points. Simplest way to correct your routine is probably just to do this - newWidth = 800 * 0.75 newHeight = 600 * 0.75 maxWidth = 1024 * 0.75 maxHeight = 768 * 0.75 If you are distributing to unknown users best to get the screen res and "points to pixels" using APIs. Regards, Peter T Hi Peter I have not been online for a few days. Thanks so much for your help. Harold |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Center spreadsheet in middle of window | Excel Programming | |||
Center displayed columns in middle of window | Excel Programming | |||
VBA to center Selected Cell in Current Window | Excel Programming | |||
how do i center the worksheet in the viewing window? | Excel Discussion (Misc queries) | |||
How to move pictures to the center of window? | Excel Programming |