View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
 
Posts: 621
Default Separating Workbooks

Stick this macro in a General Module in workbook one

Sub Tile_Open()
Windows.Arrange ArrangeStyle:=xlVertical
End Sub

Add a Call in your opening code

Private Sub Workbook_Open()
Workbooks.Open ("C:\Documents and Settings\Owner\My Documents
\MicroXSLX.xlsm")
Call Tile_Open
End Sub



Gord


On Tue, 29 Nov 2011 12:03:42 -0800 (PST), smandula
wrote:

I have VBA code calling a second Workbook

Private Sub Workbook_Open()
Workbooks.Open ("C:\Documents and Settings\Owner\My Documents
\MicroXSLX.xlsm")
End Sub

However, I can not visually separate the two workbooks, as they
overlap each other.

The two workbook icons are both visible in the Task bar.

I would like to see both workbooks separately.

With Thanks