I am trying to add onto my code. Right now if you click on the Command Button it will hide the rows that say hide. This is perfect the first time. But once the rows are hidden and I need to see a row that no longer meets the criteria it will no unhide the hidden row(s). It would be great if I could have the Command Button unhide all and then re-hide again. Or even better. Any time they make a choice in cell G4 (which is a drop down box) the macro auto runs and hides/unhides rows. The code I am using is this:

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
    Dim count As Integer
     
    For count = 7 To 557
        If Cells(count, 5).Value = "HIDE" Then
            Rows(count).Hidden = True
        End If
    Next
  Application.ScreenUpdating = True
End Sub