VBA to unlock password protected sheet using cmd button

You have not specified the issue you are facing.

i do apologise!

Basically i would like the code that will make cmd button2 work.

I require the button to open a text box, requesting the password, then if the password entered is correct then it will unlock the sheet for editing.
I have a cmd button to lock the sheet with a set password, its just the text box & unlocking i am fighting with.

Thank you very much
galvinpaddy

Might be worth mentioning, the code i have for locking is simply:

Sub ProtectOneSheet()
Sheets("Sheet1").Protect Password:="secret"
End Sub

Not sure on how to modify this to request a password when the user clicks on cmd2 button (unlock)

This is the code you need -

Sub unprotectsheet()
UserAns = InputBox("Enter the password")

If UserAns = "secret" Then
    Sheets("Sheet1").Unprotect Password:=UserAns
End If

End Sub

Great, thanks fella.
Works a treat and quick response also!! nice one 10/10
Mucho Gracias

My pleasure....thanks for the rep....

please mark as solved
Thankyou