Windows Collection Object

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.


Aa191127.parchild(en-us,office.10).gifWindows
Aa191127.space(en-us,office.10).gifAa191127.parchild(en-us,office.10).gifWindow

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.