Determining How Many Windows are Open

Summary: Does your macro need to know how many windows Excel has open? You can determine it by using the Count property of the Windows group. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

It is sometimes helpful for your macro to know how many Excel workbook windows are open at any given time. For instance, you might want your macro to only run if there is a single window open, or you might even require there to be two windows open. Either way, you need to check how many there are.

You determine the number of open windows by using the Count property of the Windows object. This is done using the following syntax:

X = Windows.Count

After executing the line, X is equal to the number of open windows.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3327) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!

Check out ExcelTips Archives today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Determining How Many Windows are Open