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
|