Carley
New Member
Little background - I am in the process of creating a productivity spreadsheet, so when a resource chooses a certain activity the times are automattically populated from pre-agreed timings spreadsheet.
However, there are some activities that the resource will need to add the times themselves. Like Training and Meetings
Is there a code that if the activity matches "Away from Desk Work Activity" either the locked timing cell opens allowing them to add there own times, or a pop up box appears asking them to enter the time which is then populated into the locked cell?
Tried the following formula but didn't react
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("F:F").Value = "Away from Desk Work Activity" Then
Range("E:E").Locked = False
Else
Range("E:E").Locked = True
End If
End Sub
However, there are some activities that the resource will need to add the times themselves. Like Training and Meetings
Is there a code that if the activity matches "Away from Desk Work Activity" either the locked timing cell opens allowing them to add there own times, or a pop up box appears asking them to enter the time which is then populated into the locked cell?
Tried the following formula but didn't react
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("F:F").Value = "Away from Desk Work Activity" Then
Range("E:E").Locked = False
Else
Range("E:E").Locked = True
End If
End Sub