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
Bookmarks