Thread: If Range1 Not Hidden on Sheet1 Then Show Range2 on Sheet2

Hi. I was hoping for a little help coding this.

I'm using this to hide and show ranges on my sheet1

If Range("Blood").EntireRow.Hidden = True Then
        Range("Blood").EntireRow.Hidden = False
    Else
        Range("Blood").EntireRow.Hidden = True
    End If

I want an onchange even i think its called.

That as soon as "Blood" range which is on sheet 1 is hidden=false (visible) THEN

a range on sheet2 i have designated Blood_Show will automatically become unhidden

as soon as that range blood is hidden again then Blood_Show would again dissapear/behidden on sheet 2


Any help with this would be really appreciated! Thanks so much!

Here's an example of what i'm trying to do but it is not working. changed sheet names....

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
  If Sheets("DISTRICT").Range("Auditorium_Cleanliness").EntireRow.Hidden = False Then
        Sheets("HOME").Range("Auditorium_Cleanliness_Show").EntireRow.Hidden = False
    Else
        Sheets("HOME").Range("Auditorium_Cleanliness_Show").EntireRow.Hidden = True
    End If
End Sub

any idea why it is not working? i want it to automatically change on home page when its changed on district page