Is there any way to tell which user entered information in a cell?

[TM74]

I'm pretty sure this is impossible, but you never know...

Someone has caused a little bit of chaos by over typing formulas with data in a live spreadsheet.

There is no way that excel can tell me which user entered information in a particular cell is there?

 

[Mike Blackman]

Hi,

There is a highlight changes function within the Tools menu you could have a look at, not used it myself.

 

[baitmaster]

not that I know of, if it has already happened

You can set up a sheet to do so in future, but its a little complex...

Can a network admin person look at the change history, and see who has been in it?

 

[TM74]

Thanks, yes I have tried the highlight changes function which is only useful if it is set up before the changes happen.

I'll have a look another way (maybe the network person way).

 

[lenze]

You can avoid this problem by protecting your worksheet or with code. You can also add a comment to cells to identify the person who makes changes.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.HasFormula = True Then
   MsgBox "You may not edit this cell"
   Range("$A$1").Select 'Make sure A1 does not have a formula
End If
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
Target.ClearComments
Target.AddComment.Text Text:="Cell changed " & Date & " by " & Environ("UserName")
End Sub

lenze

 

[TM74]

Thanks. That is very useful.