ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple Windows in Single file (https://www.excelbanter.com/excel-programming/405970-multiple-windows-single-file.html)

mcambrose

Multiple Windows in Single file
 
How do you determine which window is active in the activeworkbook when the
activeworkbook has more than one window. The problem I have is when I try to
activate a windows of a file that has more than one window, I get an error
(makes sense, since it doesn't know which window to select). Is there a way
to assign the activewindow of the activeworkbook to an object and later just
activate the object. Any other ideas are welcome.

Alternatively can I use something live workbooks("my book")windows(1).activate

Thanks for any suggestions


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com