Thank you for your instructions on protecting a cell's formula. Your macro was the only one that fully worked. The others options could be overridden and I wanted to prevent anyone from typing anything into a formula cell. I copied and pasted the following from your site:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Locked = True Then
Into view code on the worksheet tab and it worked great!
Thanks a bunch from a complete non-techie to a Master!!!
Help get this topic noticed by sharing it on Twitter, Facebook, or email.