Window proportion constraint in VB

[BugBear]

Hi all.

I have a userform in XL and I would like VB to constrain the XL window to its minimum proportions upon opening. If anyone has any ideas how to code this I would be most grateful. Thanks

 

[dave3009]

Do you want to minimise Excel? If so...

Private Sub UserForm_Initialize()
Application.WindowState = xlMinimized
End Sub

Private Sub UserForm_Terminate()
Application.WindowState = xlMaximized
End Sub

 

[Trevor G]

Add this line of code when the userform is activated

Application.WindowState = xlMinimized