Search notes:

Office Object Model: Excel - Workbook.windows

It is possible to open multiple windows on or for the same workbook. This makes it possible to work on different regions in a worksheet or different worksheets side by side.

The collection of windows is stored in the workbook's windows property. The following statement prints the number of windows on a workbook:

debug.print (activeWorkbook.windows.count)

Creating a new window

A new windows is created on the ribbon's View tab and then clicking New Window:

In Visual Basic for Applications, a new window can be created like so:

activeWorkbook.newWindow

Index