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
Did you include code to make the Application visible in your Login form ?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Put your code in Thisworkbook editor
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks