Window Object [Excel 2003 VBA Language Reference]

Multiple objects
Multiple objects

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.

Using the Window Object

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

Properties | ActiveCell Property | ActiveChart Property | ActivePane Property | ActiveSheet Property | Application Property | Caption Property | Creator Property | DisplayFormulas Property | DisplayGridlines Property | DisplayHeadings Property | DisplayHorizontalScrollBar Property | DisplayOutline Property | DisplayRightToLeft Property | DisplayVerticalScrollBar Property | DisplayWorkbookTabs Property | DisplayZeros Property | EnableResize Property | FreezePanes Property | GridlineColor Property | GridlineColorIndex Property | Height Property | Index Property | Left Property | OnWindow Property | Panes Property | Parent Property | RangeSelection Property | ScrollColumn Property | ScrollRow Property | SelectedSheets Property | Selection Property | Split Property | SplitColumn Property | SplitHorizontal Property | SplitRow Property | SplitVertical Property | TabRatio Property | Top Property | Type Property | UsableHeight Property | UsableWidth Property | View Property | Visible Property | VisibleRange Property | Width Property | WindowNumber Property | WindowState Property | Zoom Property

Methods | Activate Method | ActivateNext Method | ActivatePrevious Method | Close Method | LargeScroll Method | NewWindow Method | PointsToScreenPixelsX Method | PointsToScreenPixelsY Method | PrintOut Method | PrintPreview Method | RangeFromPoint Method | ScrollIntoView Method | ScrollWorkbookTabs Method | SmallScroll Method

Parent Objects | Application Object | Windows Collection

Child Objects | Chart Object | Pane Object | Panes Object | Range Object | Sheets Object