Protecting cells for different users

A

AndyOne

I have a excel sheet that will be processed by different users. Is i
possible to protect cells to be used only by one user?

Thanks
 
B

bigwheel

You could use VBA to unprotect the worksheet when a specific user opens it.
e.g.

Private Sub Workbook_Open()
If Application.UserName = "John Smith" Then
ActiveSheet.Protect
Else
ActiveSheet.Unprotect
End If
End Sub
 
Top