Split Window question

[Stuart]

User is working on a Workbook.
They need to reference another workbook.

I wish to split the screen and display this new book
alongside the original workbook in such a way that
they can scroll through the new sheet (or change
sheets) but still keep the original workbook displayed
alongside.

I'm going to call this new book from addin code, so if
you could also show me how to size the Windows
I'd be very grateful.

Regards.

 

[Gord Dibben]

Stuart

Sub Test()
Workbooks.Open Filename:= _
"C:\Program Files\Microsoft Office\Exceldata\filename.xls"
Windows.Arrange ArrangeStyle:=xlVertical
End Sub

Where filename.xls is the file to be opened alongside the active file.
Insert your own path to filename.xls.

Gord Dibben Excel MVP

 

[Stuart]

Windows.Arrange ArrangeStyle:=xlVertical

Many thanks.

Regards.

 

[mudraker]

with both workbooks open goto Window Menu
Select arrange
Select an arrange option
click ok butto