Blocking cells for certain users

[miguelg8]

Is there any way to block editing cells or columns for certain users?
Let's say i want:
John to edit column A
Peter to edit Column B
Peter and John column C.

Is this possible? I don't know the information they are entering, so i can't restrict the content, but want to restrict the lines they can edit.

Thanks!

 

[hatman]

Welcome to teh Board!!!

The only way I can think of to do this is to use VBA. In the Close event of the workbook, you would lock all cells on the worksheet, and protect the sheet. In the Open event of the workbook, you then use Environ("USERNAME") to determine the username of the person logged in, and unlock the appropriate cells based on the return value.

 

[lenze]

Hatman is correct in assuming you will need VBA. There are, however, several approaches, including his suggestion of using Environ("UserName"). This.however, is my approach

Private Sub Worksheet_Change(Byval Target as Range)
Select Case Target.Column
Case 1:
    If InputBox ("Enter password") <> "passwordA" Then
        MsgBox "Wrong password"
        Application.Enable.Events = False
        Application.Undo
        Application.EnableEvents = True
    End If
Case 2
   'similar code
'etc
Case Else:
End Select
End Sub

lenze

 

[miguelg8]

Thanks both!
I will try this during the weekend and let you know what my result is.

Regards

 

[miguelg8]

Thanks!