Workbooks
(1)
Macro
(1)
ArrangeWindows
(1)
WindowState
(1)
WorkbookFor
(1)
HiLook
(1)
XlNormal
(1)
Windows
(1)

minimize workbooks in macro

Asked By T Smith
29-Jan-10 02:38 AM
I have a macro that opens 6 workbooks. I want to minimize 4 of the workbooks
and arrange the remaining 2 horizontally.

HiLook at this example:Sub ArrangeWindows()Dim wb As WorkbookFor Each wb In

Per Jessen replied to T Smith
29-Jan-10 03:03 AM
Hi

Look at this example:

Sub ArrangeWindows()
Dim wb As Workbook
For Each wb In Application.Workbooks
Windows(wb.Name).WindowState = xlNormal
Next
'books to minimize
Windows("Book1.xls").WindowState = xlMinimized
Windows("Book2.xls").WindowState = xlMinimized
Windows("Book3.xls").WindowState = xlMinimized

Application.Windows.Arrange (xlArrangeStyleHorizontal)
End Sub

Regards,
Per
Post Question To EggHeadCafe