Macro to Unprotect Sheet

E

Eric

I have a sheet called Home. On this sheet, a user enters
their user name and password. There is a corresponding
sheet with that users name. I have a button that the user
will push after entering their username and password that
directs them to their password protected sheet. This gets
me to that sheet but does not unprotect the sheet.

Public Sub Button11_Click()
On Error Resume Next
Worksheets(Range("E5").Text).Activate
On Error GoTo 0
End Sub


I wanted to continue with the code so that the password
entered by the user in cell 'Home'!E7 will unprotect the
corresponding sheet so the user can make edits.

Thanks
 
Top