Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
minimize workbook
In an Open event subroutine for "workbook1" I open a second workbook
"workbook2" that is defined by the label "book2" in "workbook1" with the following statements: Dim wkbook2 as object Set wkbook2 = Range("book2") Workbooks.Open (wkbook2) Question: How do I minimize the window for "workbook2" just opened using the variable wkbook2? Following statement does not work. Workbooks(wkbook2).ActiveWindow.WindowState = xlMinimized |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moved workbook-File name, minimize, maximize and close are not vis | Excel Worksheet Functions | |||
How do I minimize | Excel Discussion (Misc queries) | |||
Buttons for Minimize, Restore and Close missing from Workbook | Excel Discussion (Misc queries) | |||
minimize just opened workbook window | Excel Programming | |||
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 |