Sweetmusic1
New Member
- Joined
- Dec 1, 2014
- Messages
- 6
Greetings! I have created a workbook with multiple worksheets. I have written the following VBA Code tied to the specific checkbox (true/false) to EXPAND a specific selection of rows when checked and to COLLAPSE the specific selection of rows when unchecked (in a seperate worksheet):
Sub ANCHORLINK()
ActiveWindow.SmallScroll Down:=-3
Sheets("Transition Worksheet").Select
If ROWS(13).ShowDetail = True Then
ROWS(13).ShowDetail = False
Else
If ROWS(13).ShowDetail = False Then
ROWS(13).ShowDetail = True
End If
End If
End Sub
What I need to also have it do is hide the rows if the check box is not checked. So that if the user checks the 4th checkbox in the list only the rows above and below the specific section in worksheet 2 hide so that the 4th selection rows move to the top when viewed & printed. Lastly, I would like to give the user the chance to check ALL the checkboxes needed without the checkbox taking the user to worksheet 2 until done checking the boxes. Thanks in advance for any insight into this!
Sub ANCHORLINK()
ActiveWindow.SmallScroll Down:=-3
Sheets("Transition Worksheet").Select
If ROWS(13).ShowDetail = True Then
ROWS(13).ShowDetail = False
Else
If ROWS(13).ShowDetail = False Then
ROWS(13).ShowDetail = True
End If
End If
End Sub
What I need to also have it do is hide the rows if the check box is not checked. So that if the user checks the 4th checkbox in the list only the rows above and below the specific section in worksheet 2 hide so that the 4th selection rows move to the top when viewed & printed. Lastly, I would like to give the user the chance to check ALL the checkboxes needed without the checkbox taking the user to worksheet 2 until done checking the boxes. Thanks in advance for any insight into this!