OLE control for workbook hidden field
 

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

OLE control for workbook hidden field
 

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



Greg Luce wrote:

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