Horizontal aligning of more than 1 excel sheets
 

Hi,

Suppose I have 3 excel workbooks A,B,C that are currently
open.
Now, I want that on click of a particular button in
Sheet 'A', my workbook A & B should tile horizontally.
The code that has been written is :

Application.Windows.Arrange
ArrangeStyle:=xlArrangeStyleHorizontal

But what this does is aligns ALL 3 A,B,C workbooks
horizontally whereas I wanted only A,B to align
horizontally.

Any hints as to how to achieve it ???

Regards
Sachin

Horizontal aligning of more than 1 excel sheets
 

Minimize C before you issue the command. (with code).

--
regards,
Tom Ogilvy

"Sachin" wrote in message
...
Hi,

Suppose I have 3 excel workbooks A,B,C that are currently
open.
Now, I want that on click of a particular button in
Sheet 'A', my workbook A & B should tile horizontally.
The code that has been written is :

Application.Windows.Arrange
ArrangeStyle:=xlArrangeStyleHorizontal

But what this does is aligns ALL 3 A,B,C workbooks
horizontally whereas I wanted only A,B to align
horizontally.

Any hints as to how to achieve it ???

Regards
Sachin