I have a login form and employee table.
In this employee table, I saved name and password.
If they enter correct name and password, they can open 4 sheets by their password to view and edit.
I used below cord on the top of the module.
Public userPass as string
Public username as String
To edit sheets, they click 'Unprotect' on the Ribbon, then enter their password to unprotect sheets.
How can I change password for sheets, so employees can see sheets?
OR, is this possible in the Excel?
Thanks.
If I am reading this correctly you want that if a person provides the correct personal credentials, they can unprotect the sheet.
The sheets themselves will have "fixed" passwords for opening. What you can do in the module that checks the person's credentials is set a global variable to TRUE.
Then give the person a button or CTRL key to run a macro to unprotect the sheet. In the code to unprotect the sheet using the sheet's password
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by dflak; 12-06-2016 at 01:45 PM.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks, I got it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks