BeforeClose on a window?

[Scotster]

I have a board display using multiple windows within Excel spread across multiple monitors. During various events windows popup to show other information and when de-activated, the window is closed.


This works like a charm until someone closes the window to deactivate it, in which instance the next window also closes.


Is there a way during the WindowDeactivate subroutine I can check to see if the action to deactivate was to close it and thus ignore any further closing?

 

[CalcSux78]

Maybe...

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then Cancel = True
End Sub

 

[Scotster]

Maybe...

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then Cancel = True
End Sub

Alas, it's not a userform. Just a bog standard window.