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
|