Take a look at the WindowResize event in VBA help files.

"Roger" wrote:

Is there an event that will run when the main Excel window is minimised -
also is there another event that will run when the user restores the window
from the start bar
--
Roger