I am building an application that has forms that overlay the the areas above and below the workbook. If a user resizes the main XL window (smaller), my forms will appear to hang out over the desktop. Ideally, I would like to use an event (like the workbook resize event) to deal with this. Is there such an event? Alternatively, is there a way to prevent the user from being able to resize the XL window?

Is this what you were after?

Sub Change_Excel_Size()
        Application.WindowState = xlNormal
        With Application
            .Left = 222.25
            .Top = 289.75
            .Width = 127.5
            .Height = 30.75
        End With
End Sub

cheers

Matt

Matt, thanks for taking the time to reply.

Your solution tells how to re-size, but my burning need is to have my code know WHEN to resize, or as an alternative, how to prevent the user from re-sizing the XL app window.