Ok I have ran out of options. I'm trying to create a Macro that will let me do the following.
If I5:I24 equal "x", then K5:K24 are unlocked
If I5:I24 is blank or anything else, then K5:K24 are locked.
I don't need the entire K range locked if just I5 is blank or anything else. I need I5 to correspond with K5, I6 to correspond with K6, and so on...
In addition to this, I need this same macro to work on seven tabs in the workbook. SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY
In addition, the sheets have to be protected as well.
This is what I have so far (if it's not in code I'm sorry this is my first post)
/Private Sub Worksheet_Change(ByVal Target As Range) Select Case Me.Range("I5") Case "X", "x" With Me .Unprotect .Range("K5").Locked = False .Range("I5").Locked = False .Protect End With Case Else With Me .Unprotect .Range("K5").Locked = True .Range("I5").Locked = False .Protect End With End Select
This only works for I5 and K5 cells. I can't figure out how to do it for an entire range or on multiple sheets.
Any help would be GREATLY appreciated.