Lock cell without protecting worksheet

Christina333 

You could use VBA code to prevent some cells from being edited, but that only helps with accidental edits. Someone who knows a bit about Excel can easily circumvent it by either opening the workbook without allowing macros, or by temporarily disabling events.

Here is what you could do:

• Right-click the sheet tab.
• Select 'View Code' from the context menu.
• Copy the code listed below into the worksheet module.
• Change A2,C2,A4,C4 to the list of cells that you want to protect. You can use ranges too: A2:B10,D2:H10
• Switch back to Excel.
• Save the workbook as a macro-enabled workbook (*.xlsm).
• Instruct users to allow macros when they open the workbook.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Range("A2,C2,A4,C4"), Target) Is Nothing Then
        Application.EnableEvents = False
        Application.Undo
        Application.EnableEvents = True
    End If
End Sub