View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sachin[_2_] Sachin[_2_] is offline
external usenet poster
 
Posts: 1
Default 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