Below is the code I've been using to hide or show a row based if "yes" or
"no" is selected in a validation box. This has been working. Now I would
like to also hide a Tab if "no" is selected. How can I had a tab in addition
to a row? Thanks!


Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Range("171:186").EntireRow.Hidden = (LCase(Range("b92")) = "no")


End Sub