Multiple windows mayhem

[nigelandrewfoster]

If my workbook has 3 windows, called A,B and C (their names will vary) and Windows(1) is always the active window (let's say it's A at present), then how do I know if Windows(2) corresponds to B or C? Had a right load of fun with it this afternoon. Then I add a new window. What's the computer going to call that, and what index number will that one be referred to by? It seems to be making it up as it goes along.

 

[pgc01]

Hi

It's good practice to name the windows as you create them, or else it can get confusing.

For ex., in a new workbook execute:

Sub Macro1()
 
ActiveWindow.Caption = "A"
ActiveWindow.NewWindow.Caption = "B"
ActiveWindow.NewWindow.Caption = "C"
Windows("A").Activate
End Sub

The index represents the order of activation (most recent first). So, after running this code you'd get (A,1), (C,2), (B,3).

A better way is to assign the windows to variables. This way you can easily refer to them using the variables.

Sub Macro1()
Dim winA As Window, winB As Window, winC As Window
 
Set winA = ActiveWindow
Set winB = winA.NewWindow
Set winC = winA.NewWindow
 
' for ex., change caption of winB and activate winA
winB.Caption = "B"
winA.Activate
End Sub

 

[nigelandrewfoster]

Thanks for that. Very helpful indeed. One final question: Your method of declaring and defining the windows at the beginning is what I want to do. Sometimes, though, I only want one of the windows visible, I had been using the .CLOSE method, but that means redefining it again, checking how many are open, etc. Can unused windows be temprarily hidden in some way?

 

[pgc01]

Hi

You can hide the window:

winC.Visible = False

 

[nigelandrewfoster]

Great. I think I have all I need now. Very helpful, thank you.

 

[pgc01]

I'm glad it helped. Thanks for the feedback.