Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m Thankful
Adina Conroy November 05, 2012 23:23

Not a techie but your instructions worked!

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!!!
Reply