Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Aligning charts in excel | Charts and Charting in Excel | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) | |||
Aligning decimals in Excel ... | Excel Discussion (Misc queries) | |||
Excel, horizontal scroll bar and sheets not accessable anymore | Excel Discussion (Misc queries) | |||
Aligning Two Lists in Excel | Excel Discussion (Misc queries) |