View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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