I have a workbook that has 11 tabs. 1 is a summary page, and the other 10 are the variable sheets. The 10 variable sheets have check boxes for about 30 different values per sheet to choose from. The summary sheet shows all (roughly 300 items) of the data from all 10 of the variable sheets. Column E in the summary sheet shows an "x" when the box is unchecked in the variable sheets, and shows "Have" when it is checked. I wanted all the rows where the value in the E column was "Have" to automatically hide the entire row. I inserted the following as a sheet module:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In Range("E:E")
If cell.Value = Have Then
cell.EntireRow.Hidden = True
ElseIf cell.Value = x Then
cell.EntireRow.Hidden = False
End If
Next
Application.ScreenUpdating = True
End Sub
That worked perfectly. But after the initial hiding of the rows with the Value of "Have" in the E column, i can check boxes in the 10 variable sheets, the summary page with the macro will still update from "x" to "Have", but in order to have it auto-hide, i have to make any cell active, then hit enter and the macro will work. I am an extreme VBA noob. Is there anything that seems wrong with what I've done? Thank you for the help!
Bookmarks