Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Update of a field referencing to a field in another workbook | Excel Worksheet Functions | |||
Sort Pivot Table using hidden data field | Excel Discussion (Misc queries) | |||
How can I control the positioning of the Comments field? | Excel Discussion (Misc queries) | |||
How do you control the font size of the data validation field? | Excel Discussion (Misc queries) | |||
Updating Page Field of Pivot Tables from Form Control | Excel Discussion (Misc queries) |