I have set a code to open a login box when the workbook is opened. The password works but the workbook wont open until I open up a different document, then the one I want to open will open up.
This is the code I have used, am I missing something?

Private Sub Workbook_Open()
Application.Visible = False: Login.Show
End Sub