Skip to main content

Window object

Table of contents
  1. Remarks
  2. Example

Represents a window.


Many worksheet characteristics, such as scroll bars and gridlines, are actually properties of the window. The Window object is a member of the Windows collection.

The Windows collection for the Application object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook.


Use Windows (index), where index is the window name or index number, to return a single Window object. The following example maximizes the active window.

Windows(1).WindowState = xlMaximized

Note that the active window is always Windows(1).

The window caption is the text shown in the title bar at the top of the window when the window isn't maximized. The caption is also shown in the list of open files on the bottom of the Windows menu. Use the Caption property to set or return the window caption. Changing the window caption doesn't change the name of the workbook.

The following example turns off cell gridlines for the worksheet shown in the Book1.xls:1 window.

Windows("book1.xls":1).DisplayGridlines = False

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>