Hi!
I require help for this problem. I want to hide certain rows when user are not using the table and show when the button is depressed. I'm using the forms toggle button but I overlapped a few similar rows. The end result when I depress the top button, the bottom button keep showing. I want it to disappear. Can this be done? Is there other alternatives beside grouping? Thanks in advance
Private Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
'This area contains the things you want to happen
'when the toggle button is not depressed
Sheet7.Rows("108:204").EntireRow.Hidden = False
Else
'This area contains the things you want to happen
'when the toggle button is depressed
Rows("108:204").EntireRow.Hidden = True
End If
End Sub
Private Sub ToggleButton2_Click()
If ToggleButton2.Value = True Then
'This area contains the things you want to happen
'when the toggle button is not depressed
Sheet7.Rows("131:169").EntireRow.Hidden = False
Else
'This area contains the things you want to happen
'when the toggle button is depressed
Rows("131:169").EntireRow.Hidden = True
End If
End Sub
Private Sub ToggleButton3_Click()
If ToggleButton3.Value = True Then
'This area contains the things you want to happen
'when the toggle button is not depressed
Sheet7.Rows("173:202").EntireRow.Hidden = False
Else
'This area contains the things you want to happen
'when the toggle button is depressed
Rows("173:202").EntireRow.Hidden = True
End If
End Sub
Bookmarks