Which event is triggered when maximizing a workbook?

[madamson86]

Hello

I have setup a userform and need to allow the user to minimize the form so that they can use other workbooks that they have got open. When the user selects to minimize the form the userform is hidden then the workbook is minimized but I need the form to show again as soon as they maximize the workbook. Is there an event that is triggered when they do this?

Cheers
Mike

 

[iliace]

If only the Workbook is maximized, then you can use the Workbook-level WindowResize event and check that WindowState = xlMaximized.

If the whole application is maximized, the Workbook-level event is not triggered, so you would have to create an application-level event handler. But the principle is the same: trap WindowResize event and check WindowState.