Windows Collection Object

A collection of all the Window objects in the Spreadsheet control. The Windows collection for the Spreadsheet object contains all the windows in the application, whereas the Windows collection for the Workbook object contains only the windows in the specified workbook. In both cases, the Spreadsheet object contains only one Window object. This object represents the window for active sheet within the workbook.

Each sheet has a distinct Window object associated with it. Application.ActiveWindow or Application.Workbooks(1).Windows(1) always returns a pointer to the active sheet's window. There is no ActiveSheet.Window or Sheets(i).Window.

Using the Windows Collection Object

The following properties return a Windows collection.

The Spreadsheet object's Windows property

The Workbook object's Windows property.