MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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