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
Me.Protect Password:="Secret"
Else
Me.Unprotect Password:="Secret"
End If
End Sub
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.


-
Hi Adina,
I'm glad you found that to be useful information. If you ever have any questions or issues with the content of our books, please let us know at booktech@oreilly.com and we can get you some help.
Cheers,
Tai H.
Customer Service Rep,
O'Reilly Media -