User to Enter password to be able to unlock pages

[hello123456789101112]

Hello,

I am working on a document for work which needs to have some tabs hidden and protect. All well and good, however where I have stumbled is for entering in a password only once for the multiple pages.

I don't want everyone to have access to this, so I want the admin to enter in the correct password. I had found a code but even if I put in the correct password it doesn't work.

I a fairly new to vba so any help would be greatly appreciated. Current code below:

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you only have a couple of posts. --6StringJazzer

[6StringJazzer]

Please show us the code for UnProtectSheets. If you are entering the correct password, the problem could be there.

Also be aware that this method will work only for compliant users. A malicious user can easily defeat a VBA password scheme. Also, the user has to allow macros to run for it to work at all.

[hello123456789101112]

Thanks for the quick reply:

Sub UnProtectSheets()
Dim ws As Worksheet
Dim wsArray
Set wsArray = Sheets(Array("sheet 1", "sheet 2", "sheet 3"))
For Each ws In wsArray
If ws.ProtectContents = True Then
ws.Unprotect "test"
End If
Next ws
End Sub

[hello123456789101112]

Got it working, thanks for your help.

[6StringJazzer]

I fixed your code tags with a notice in the first post, but now I will have to ask you to update post #3.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)