Windows object (Excel)

A collection of all the Window objects in Microsoft Excel.

Remarks

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.

Example

Use the Windows property to return the Windows collection. The following example cascades all the windows that are currently displayed in Microsoft Excel.

Windows.Arrange arrangeStyle:=xlCascade

Use the NewWindow method to create a new window and add it to the collection. The following example creates a new window for the active workbook.

ActiveWorkbook.NewWindow

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.

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

Windows(1).WindowState = xlMaximized

Methods

• Arrange
• BreakSideBySide
• CompareSideBySideWith
• ResetPositionsSideBySide

Properties

• Application
• Count
• Creator
• Item
• Parent
• SyncScrollingSideBySide

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.