akanowhere
New Member
- Joined
- Jan 4, 2021
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Theres no merge cell in this sheet. That sheet is locked.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A11") <> "" Then
Range("B1:L11").Locked = False
ElseIf Range("A11") = "" Then
Range("B11:L11").Locked = True
End If
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("A11") <> "" Then
Range("B1:L11").Locked = False
ElseIf Range("A11") = "" Then
Range("B11:L11").Locked = True
End If
End Sub