Locking - Please help

[mm178]

I have a log book for my H.S. students to enter info. I need to make it so that when one row of information is filled in, then it is not longer editable.

Once they enter an item they can not delete that entry (Several cells in on row)

I am using Excel 2003

Any IDEAS

Please Help?

 

[jproffer]

Private Sub Worksheet_Change(ByVal Target As Range)
   ActiveSheet.Unprotect "password"
   Target.Locked = True
   ActiveSheet.Protect "password"
   ActiveSheet.EnableSelection = xlUnlockedCells
End Sub

Try that in the worksheet code module.

Remember that all the cells are locked by default, so you'll have to unlock all of them (or whichever apply) before protecting the sheet with your password.

 

[mm178]

Will this work if each tab has a password that the students have to put in before they can add an item. This is to keep other students from entering info on each others tabs


Also if a students makes a mistake is there a password to put in to over write the locking?