biocentrism
Board Regular
- Joined
- Jul 28, 2014
- Messages
- 187
Under View-->Window-->New Window you can open a new "window" of the workbook you are working on. This adds a " - 1" and a " -2" to the name of each window in the upper bar header.
I am trying to figure out how to loop through each of the windows using the VBA.
For instance if my Workbook is called "Book1.xlsm" and I have 2 Windows displayed showing this workbook. And then I want to go to Window1 and activate Sheet1. And then I want to go to Window2 and activate Sheet2.
How would I write the code for this?
Thanks.
I am trying to figure out how to loop through each of the windows using the VBA.
For instance if my Workbook is called "Book1.xlsm" and I have 2 Windows displayed showing this workbook. And then I want to go to Window1 and activate Sheet1. And then I want to go to Window2 and activate Sheet2.
How would I write the code for this?
Thanks.