Lock cell entry

G

Guest

Is there a way to prevent changing, or re-entering data in an Excel cell
after initial entry?
 
B

Bernie Deitrick

Sprankler,

Copy the code below, right click on the sheet tab, select "View Code" and paste the code in the
window that appears.

HTH,
Bernie
MS Excel MVP

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

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

Array formula lock-up 1
Cell Locking Question 2
automatically locked cells 4
Lock after entering 1
Conditional Formatting 5
Can a row containing protected & unprotected cells be copied? 8
Validate data but then change the entry to upper case 4
Excel - How to get tab to go to next unlocked cell across columns 3

Top