Multiple excel windows
 

Hi,

How can list all open excel windows and activate a other window by VBA
code ?

Regards,

wbl


---
Message posted from http://www.ExcelForum.com/

Multiple excel windows
 

Wbl,

Does this help?

Dim win As Window

For Each win In Windows
Debug.Print win.Caption
Next win

Windows("Book1").Activate



--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"wbl " wrote in message
...
Hi,

How can list all open excel windows and activate a other window by VBA
code ?

Regards,

wbl


---
Message posted from http://www.ExcelForum.com/