Application.WindowHide Method

Project Developer Reference

Hides a window.

Syntax

expression.WindowHide(Name)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Name Optional String The name of the window to hide. The name of a window is the exact text that appears in the title bar of the window. The default is the active window.

Return Value
Boolean

Example
The following example hides all windows except the active window.

Visual Basic for Applications
  Sub HideAllWindowsExceptActive()
Dim I As Long   ' Index for For...Next loop

For I = 1 To Windows.Count
    If Windows(I) <> ActiveWindow And Windows(I).Visible Then
     
			<strong class="bterm">WindowHide</strong> Windows(I).Caption
    End If
Next I

End Sub

See Also