Hiding Rows based on Tab

[gavakie]

Can I hide rows based on a tab being hidden. What im looking to do is if a tab is hidden on another tab where Im getting that info from I want that row to hide its self.

 

[Ralajer]

Welcome to the board gavakie,

If I am reading you correctly you want to hide a row or set of rows on one sheet if another sheet is hidden. Example if Sheet2 is hidden on Sheet1 hide rows 1 to 10.

Sub rowHideBySheet()

   '// Rows to hide are on Sheet1
    With Sheets("Sheet1")
        .Rows("1:10").EntireRow.Hidden = Not (Sheets("Sheet2").Visible)
        .Rows("11:20").EntireRow.Hidden = Not (Sheets("Sheet3").Visible)
    End With

End Sub

The above will both hide and unhide depending on sheet visibility. You just have to change the sheet names and rows to match you application.