So i have a userform in excel that I've added a button to that minimizes the form for me. On workbook_open I have a code to make the application hidden "application.visible = false" and everything is great however once i minimize my form and then click it from the bottom to open it back up, the sheet is no longer hidden. I can add another button to hide it again or use the mouseover event however i was wondering if there is a slicker way of doing this where the sheet is never shown even once i maximize my form back up.
This is the code i use to minimize
Private Sub CommandButton6_Click()
Application.WindowState = xlMinimized
End Sub
This is the code i use to minimize
Private Sub CommandButton6_Click()
Application.WindowState = xlMinimized
End Sub