Firstly, I know 0 about programming or VBA, but I found this code which auto locks cells after you enter data in them.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error Goto justenditall
Application.EnableEvents = False If Not Intersect(Target, Range("A1:A20")) Is Nothing Then If Target.Value <> "" Then ActiveSheet.Unprotect Password:="thepassword" Target.Locked = True End If End If
justenditall: Application.EnableEvents = True End Sub
Now I want to make this only work when the file is saved. For example, when an employee opens up the file he or she is able to enter any new data, but not edit old data, and once saved, they will not be able to edit the data they just entered.
I hope this makes sense.