Hi, i have 2 button for hiding and showing certain rows, but i would like to make it possible to hide/show rows with only one button.
When i click once it shows the cells, when i click again it hides the rows.
Here are the codes:
Private Sub CommandButton1_Click()
Rows("28:36").Select
Selection.EntireRow.Hidden = False
End Sub
Private Sub CommandButton3_Click()
Rows("28:36").Select
Selection.EntireRow.Hidden = True
End Sub
When i click once it shows the cells, when i click again it hides the rows.
Here are the codes:
Private Sub CommandButton1_Click()
Rows("28:36").Select
Selection.EntireRow.Hidden = False
End Sub
Private Sub CommandButton3_Click()
Rows("28:36").Select
Selection.EntireRow.Hidden = True
End Sub