View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JohnZ[_2_] JohnZ[_2_] is offline
external usenet poster
 
Posts: 4
Default 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