I have a user form that automatically opens when the workbook is opened, and it uses Application.Visible = False to hide the workbook during form entry. I want to make the workbook visible again through a command button, but while Excel does become Visible, it also opens 2 blank instances of Excel that I have to use Task Manager to close. I've been trying to troubleshoot it, but not sure how it's opening the other instances. Here's my code for the command button to make Excel visible again:
VBA Code:
Private Sub cmdSupervisor_Click()
Application.Visible = True
Unload Me
End Sub