Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
minimize workbooks in macro
I have a macro that opens 6 workbooks. I want to minimize 4 of the workbooks
and arrange the remaining 2 horizontally. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
minimize workbooks in macro
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 "T Smith" <T skrev i meddelelsen ... I have a macro that opens 6 workbooks. I want to minimize 4 of the workbooks and arrange the remaining 2 horizontally. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro is slow when I minimize spreadsheets | Excel Programming | |||
"minimize multiple excel workbooks on windows taskbar" | Excel Discussion (Misc queries) | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
Minimize Excel When Running a Macro | Excel Programming | |||
Minimize Excel When Running a Macro | Excel Programming |