| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lock cell entry
Is there a way to prevent changing, or re-entering data in an Excel cell
after initial entry? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lock cell entry
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" wrote in message ... Is there a way to prevent changing, or re-entering data in an Excel cell after initial entry? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation to force entry in a cell | Excel Worksheet Functions | |||
| how can i lock cell immediately if any value Entered? | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel | |||
| resolving a numeric cell entry for its meaning | Excel Worksheet Functions | |||
Hybrid Mode
