Afternoon happy campers,
First off - This is not a request to bypass or break a password, i have the password and want to know how to modify my current code. 
I have the following code in one of my sheets:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Dim myPassword As String
Dim wSheet As Worksheet
myPassword = "pass123"
If Environ("USERNAME") = "joe.bloggs" Then
For Each wSheet In ActiveWorkbook.Worksheets
wSheet.Unprotect Password:=myPassword
Next
End If
If Environ("USERNAME") = "bob.hope" Then
For Each wSheet In ActiveWorkbook.Worksheets
wSheet.Unprotect Password:=myPassword
Next
If Environ("USERNAME") = "no.hope" Then
For Each wSheet In ActiveWorkbook.Worksheets
wSheet.Unprotect Password:=myPassword
Next
Application.ScreenUpdating = True
End Sub
Which works fine, however, i want to add code to it that will look at the username, and if for example the user is 'Tom.Jones' then the code would only unlokc 'Sheet.3' and nnot the whole file.
Your help, as always is greatly appreciated.
Bookmarks