Good morning,
I need help adding in additional code to a checkbox that hides rows on the same sheet as the checkbox. I need to add code that also hides and unhides cells on a different sheet. Below is the code I'm using. If the check box is marked, it needs to unhide row 6 on sheet "Service Plan". If unchecked, it hides row 6.
Private Sub CheckBox1_Click()
If CheckBox1 = True Then
[42:90,111:116].EntireRow.Hidden = False
Else: [42:90,111:116].EntireRow.Hidden = True
End If
End Sub