Resize Excel Window to the Size of a Userform

[breynolds0431]

Hello. I have a userform that launches on workbook_open. Is there a way to resize the excel window so that it's the same size of the userform and would sit directly behind the userform?

 

[FuNeS13]

when you move the userform the excel window will be visible... why not use this code when opening the file:

Private Sub Workbook_Open()
Dim Wk As Workbook
Set Wk = ThisWorkbook

With Wk
    Application.Visible = False
    UserForm1.Show vbModeless
End With

End Sub

Careful thou, it might hide your other excel windows as well...