Hello. I have a login screen for an Excel file. The username is in Combobox 10 and the password is in Textbox 10. I want a way. When I enter the password incorrectly 2 times, the file is locked for 30 minutes and cannot be opened until after that time. Even if anyone tries to open it, it is locked automatically.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Prevent opening the workbook on condition
- Thread starter sofas
- Start date
Candyman8019
Well-known Member
- Joined
- Dec 2, 2020
- Messages
- 1,082
- Office Version
- 365
- Platform
- Windows
You could record the user name failure times in a specific area of a sheet and upon opening the workbook, confirm that time is more than 30 minutes in the past...HOWEVER...in order for that to work, the user would need to "enable content" when they open the workbook to allow the code to run. If they don't allow it, they'll still be able to open the workbook.
Upvote
0
I use the feature to hide the workbook and show the user form in Private Sub Workbook_Open() as I think that when the password is entered incorrectly, the macro will already be activated on my end.
Upvote
0
