I have a group of 3 option buttons and each option button relates to a group of few rows. In my code option buttons names are "Gumbmogućnosti".
What Im trying to do is to hide rows depending on which option button is chosen. I would like Excel to automatically display (i.e. unhide) 3 rows and hide the other 9 rows (i.e. the other 2 sets of rows).
I tried to find solution on internet but nothing works for me. This is one example what I tried but I got "error 424- Object required".
Private Sub Gumbmogućnosti2_Klikni()
If Gumbmogućnosti2.Value = True Then
Rows("11:14").EntireRow.Hidden = False
Rows("16:18").EntireRow.Hidden = True
Rows("20:23").EntireRow.Hidden = True
End If
End Sub
Private Sub Gumbmogućnosti3_Klikni()
If Gumbmogućnosti3.Value = True Then
Rows("11:14").EntireRow.Hidden = True
Rows("16:18").EntireRow.Hidden = False
Rows("20:23").EntireRow.Hidden = True
End If
End Sub
Private Sub Gumbmogućnosti4_Klikni()
If Gumbmogućnosti4.Value = True Then
Rows("11:14").EntireRow.Hidden = True
Rows("16:18").EntireRow.Hidden = True
Rows("20:23").EntireRow.Hidden = False
End If
End Sub