Application Window State Event

Posted by George Clements on July 06, 2001 8:45 AM

Does anyone know how I can make a macro run when the excel application window is maximised by the user?

Please help

Thanks

George

Posted by Damon Ostrander on July 06, 2001 1:14 PM

George,

You can use the Application object's WindowResize event for this. If you haven't used application object events before, look in the VBA helps under Application Object Events, and read about "Using Events with the Application Object" VERY CAREFULLY. It's a bit tricky.

Damon