Is there a way to prevent changing, or re-entering data in an Excel cell after initial entry?
S Sprankler Nov 17, 2005 #1 Is there a way to prevent changing, or re-entering data in an Excel cell after initial entry?
B Bernie Deitrick Nov 17, 2005 #2 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
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
