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

TM74

Board Regular
Joined
Aug 2, 2007
Messages
132
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?
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Mike Blackman

Well-known Member
Joined
Jun 8, 2007
Messages
2,494
Hi,

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

baitmaster

Well-known Member
Joined
Mar 12, 2009
Messages
2,039
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

Board Regular
Joined
Aug 2, 2007
Messages
132
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

Legend
Joined
Feb 18, 2002
Messages
13,690
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.
Code:
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
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
Target.ClearComments
Target.AddComment.Text Text:="Cell changed " & Date & " by " & Environ("UserName")
End Sub

lenze
 

Watch MrExcel Video

Forum statistics

Threads
1,122,509
Messages
5,596,561
Members
414,077
Latest member
ammylar5

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top