Application Maximise event

[lyle]

Hi all,

Is there an event I can use to trap the maximisation of the Excel App?

(ideally an event that traps the move from minimised to any other
state)

Thanks,

Lyle

 

[JLGWhiz]

Not sure if this is what you are looking for. I got it from the VBA help
file under window resize event.

Private Sub Workbook_WindowResize(ByVal Wn As Excel.Window)
Application.StatusBar = Wn.Caption & " resized"
End Sub