Multiple objects![]() ![]() ![]() |
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
.
The following properties return a Windows collection.
The Spreadsheet object's Windows property
The Workbook object's Windows property.