I have a complex sample logging workbook. There are some locked cells and a before doubleclick vba code to insert date and name. I have the following code which allows the code to modify without unprotecting and reprotecting 
Worksheets("LogIn").Protect "password", True, True, True, userinterfaceonly:=True
    If Target.Column = 2 Or Target.Column = 4 Then
        Target.Value = Now()
        Target.Offset(0, 1).Value = Environ$("UserName")
    End If
Works fine when I do it. So I send it to someone else and they save it but when they do a double click, they get the typical "this cell is protected blah blah" Any thoughts on this?
Thanks in advance.