Protect data in cells after entered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need a worksheet where data can be entered but, once it is entered can not be
changed. The purpose of this is for accountability. Example: If you enter
a customers name on a worksheet and an amount of money they owe you should
not be able to delete/dhange that data in the future but only add additional
data to the worksheet.
 
Hi Jeff

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
ActiveSheet.Unprotect
Target.Locked = True
ActiveSheet.Protect
End Sub

Try this event in a sheet module
First change locked in all cells in the worksheet
select the cells and press Ctrl-1 and uncheck locked on the
protection tab
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Password Protect Specific Range Of Cells 6
Inserting a comment box in a protected worksheet 2
Data Forms 2
Locking cells automatically after enter 2
CAN EXCEL TELL ME IF I ENTER THE SAME DATA TWICE? 4
Can't access cells 2
Entering photos or pdf into a protected sheet 1

Back
Top