Hello AKRAMI,
I have modified your "Database" page to include a new column labeled "Locked". There is a cell for each user. If it is TRUE then the user can not login until the "Locked" cell has been changed back to TRUE. The user will be locked out after 3 failed attempts.
The Table on "Database" has three dynamic named ranges: Users, Passwords, and Locked. You can add or remove users from these lists and not have to modify the UserForm code. The attached workbook has all the changes made to it.
UserForm Code
Bookmarks