Windows Collection Object

Description

A collection of all the Window objects in the Microsoft Excel application. 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.

Accessors

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 the Windows method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example cascades all the windows currently showing in Microsoft Excel.


Windows.Arrange arrangeStyle:=xlCascade

Properties

Application Property, Count Property, Creator Property, Parent Property.

Methods

Arrange Method, Item Method.