Hi,

I have a workbook and use the following code to open it with the window set at certain size. This part works great, however the workbook is used on different size screens and if the maximize button is clicked it looks bad on large screens. Minimizing is ok because it returns to the set size... so is there a way to disable the maximize button, not allow maximizing, or keep the window the set size no matter what.

Private Sub Resize()
Application.WindowState = xlNormal
    Application.Top = 20
    Application.Left = 20
    Application.Width = 800
    Application.Height = 500
End Sub