Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello;
I've an Excel file (A.xls) that opens (via a VB macro) 2 other Excel files (B.xls and C.xls), and arranges the 3 windows horizontally (on a 17" laptop screen) as follows (arrived at by trial & error, and it works fine): Sub OpenArrange_1() .................................................. ........................ ' for A.xls, full width of screen ................................................ With ActiveWindow .Width = 1074.74 .Height = 326.25 End With ................................................ ' for B.xls, bottom left of screen ................................................ With ActiveWindow .Top = 328 .Left = 1 .Width = 534 .Height = 332.25 End With ................................................ ' for C.xls, bottom right of screen ................................................ With ActiveWindow .Top = 328 .Left = 534.5 .Width = 543.83 .Height = 332.25 End With .................................................. ......................... How can I have the same above arrangement (proportionally) on different size monitors without having different versions of the above code for each monitor ?? Thank you kindly. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to set up a page to display full screen on any size monitor | Excel Discussion (Misc queries) | |||
open separate Excel windows in dual monitor environment | Setting up and Configuration of Excel | |||
Arranging the VBA console windows | Excel Discussion (Misc queries) | |||
Arranging Windows | Excel Programming | |||
arranging charts and visible screen size | Excel Programming |