Horizontal aligning of more than 1 excel sheets

  • Thread starter Thread starter Sachin
  • Start date Start date
S

Sachin

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
 
Back
Top