Good day all once again,
I have a workbook attached (made up from numerous codes found while spending hours on this amazing site) that uses multiple passwords & usernames, I have a worksheet table that holds all the usernames & password & also grants them either limited access or full access. Just when I thought I had it...I tweaked part of the access code & now have two further issues I can't undo:
1st is when you enter the correct code it allows access as specified but still tries to close the workbook?
2nd is when you enter a complete wrong password or no text at all the workbook closes without showing my message box "Incorrect Information - Access Denied - Workbook will now close"
If the text entered is almost correct I do have a msgbox that say "Almost but not quite" & closes the workbook but if possible i would love to have three attempts if the text entered is almost right, this is not important but would make the workbook Perfect! Thank you again guys for any assistance with this & have a fantastic day - Marco
Bookmarks