OLE control for workbook hidden field

[Greg Luce]

In Excel under the Window menu there are hide and unhide menu options to
hide and unhide workbooks. However, the workbook object does not have a
visible or hide property. How, using OLE, can I view and change the hidden
status for workbooks?

Greg

 

[Dave Peterson]

In VBA, I'd use something like:

Dim myWindow As Window
Dim wkbk As Workbook

Set wkbk = Workbooks("someworkbooknamehere.xls")

For Each myWindow In wkbk.Windows
myWindow.Visible = False
Next myWindow