login, userid, spreadsheet

[Devalkenier]

I work with 20 people, each has windows login. We work with 1 Excell-spreadsheet.
I want to know who changed a cell in this spreadsheet.

[sintek]

Create another sheet in workbook and record all changes...Something like this...
Place this code in the sheet Module of sheet that changes are made in...can also add time if you like in a third column...
This will record Name and which cell was changed in sheet("Record Changes") every time a user changes cells in Sheet1

Please Login or Register  to view this content.

[Devalkenier]

Thank you !!!!