I want to protect ranges of cells or specific cells in a worksheet when the worksheet containing

[Tanner_2004]

the locked and unlocked cell is open/Active.
Instead of "globally" protecting the whole worksheets to enable the "Locked" cell formating, I want to still format the cells as locked, but only protect sections, cells or ranges of cells within the worksheet.

Thank you!

 

[Tanner_2004]

I found this in a post from 2002! I did the trick for me!
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If ActiveCell.HasFormula Then
MsgBox ("Formula in cell do not remove or change!")
Else
End If
End Sub