Conditional unlock
Hi,
You can doo it using a change event. This check B1 which must be unlocked
and if the value changes to 999 then A1 becomes unlocked
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Or IsEmpty(Target) Then Exit Sub
If Not Intersect(Target, Range("B1")) Is Nothing Then
If Target.Value = 999 Then
ActiveSheet.Unprotect Password:="mypass"
Range("A1").Locked = False
Else
Range("A1").Locked = True
End If
ActiveSheet.Protect Password:="mypass"
End If
End Sub
Mike
"johnsail" wrote:
Hi
Is it possible to unlock a cell dependent on a specific value being entered
in anther cell in the same row?
|