jonnynacker
New Member
- Joined
- Sep 11, 2014
- Messages
- 46
I currently have a spread sheet with several command buttons on it which expands / collapses various rows. the code I use for each button isPrivate Sub CommandButton5_Click()
Rows("12:13").Select
Selection.EntireRow.Hidden = IIf(Selection.EntireRow.Hidden, False, True)
End Sub. I am looking to insert a command button at the top which will expand / collapse all of these sub command buttons regardless of which state they are in. Please help
Rows("12:13").Select
Selection.EntireRow.Hidden = IIf(Selection.EntireRow.Hidden, False, True)
End Sub. I am looking to insert a command button at the top which will expand / collapse all of these sub command buttons regardless of which state they are in. Please help