Password lock for Worksheet in a excel workbook

[z3162238]

I am currently using a script that I can set user name and password in a excel workbook that allow users to view only one assigned worksheet. Can anyone help to adjust the code so that one user can view multiple sheets?

heres the code im using.

Please Login or Register  to view this content.

Mod note: code tags added for you - this time

[JBeaucaire]

So one user can view ALL sheets, or each user can view specific other sheets out of all possible sheets?

Here's a page outlining either option:

Password Protect Hidden Sheets or Password Protect Sets of Hidden Sheets.

[z3162238]

I want a user able to view multiple sheets heres the file im usingExcel with Password lock.xlsm

[JBeaucaire]

The page noted in post #2 provides all the code and a sample workbook ready for you to adapt into your project.

[z3162238]

Im sorry im very armature with macro, I dun know how to merge the two code together. It unlock multiple sheets but it doesn't have user id can we add It to the script?

[JBeaucaire]

Well, then, whoever created this current password lock system for you has seriously overcoded it, all because you are using a userform. I think the biggest fail here is that you now have a workbook full of code I'm guessing you don't understand at all.

There's no need for a form at all, as demonstrated in the much simpler example I showed.

Truth is, there's no need to enter a "username" either. A password is all that is needed, the username can be implied. Take another serious look at the much simpler approach to the same end provided in my sample workbook.

Here's yours back with the expansion for multiple sheets added, buried deep in the convolution.

[z3162238]

you are very correct, as the code is very complicated which I hardly understand any of it.

The reason why I need to add user name is I assigned the user with password, so i figure if I combine user name plus password it would be harder for them to guess.

When I downloaded the spreadsheet, and tried it with one of the user name and ID it doesnt open up the sheets rather it prompt with pop up box saying the login is correct

[JBeaucaire]

Which one did you try?

[z3162238]

I tried Makei and Freark

[JBeaucaire]

the sheet in post #6 has been updated.

[z3162238]

Thank you very much it worked perfectly
how can I change my post to solved?

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.