J
jday
I have a worksheet that contains option buttons where a user can "check"
which sections of the worksheet they wish to view. When the user either
checks or unchecks a box, the designated rows for that box are unhidden (if
they uncheck the box, the rows are hidden again). Within this same
worksheet I am using the Excel Group function to define two levels of detail
-- if the user selects Group 1 in the Excel grid, certain rows are collapsed,
if they select Group 2, these rows are visible.
The issue I am having is when the user tries to select Group 2 after they
have chosen which sections they wish to view via the checkbox buttons. Let's
say the user has chosen to view sections 1-4. This works fine as long as
they are viewing Group 1 (details hidden), but if they select Group 2
(details expanded), the detail rows are expanded/unhidden for ALL sections
1-8 --- not just sections 1-4. Is there anything I can do to keep the
grouped rows from expanding if the user does not want to view that section?
which sections of the worksheet they wish to view. When the user either
checks or unchecks a box, the designated rows for that box are unhidden (if
they uncheck the box, the rows are hidden again). Within this same
worksheet I am using the Excel Group function to define two levels of detail
-- if the user selects Group 1 in the Excel grid, certain rows are collapsed,
if they select Group 2, these rows are visible.
The issue I am having is when the user tries to select Group 2 after they
have chosen which sections they wish to view via the checkbox buttons. Let's
say the user has chosen to view sections 1-4. This works fine as long as
they are viewing Group 1 (details hidden), but if they select Group 2
(details expanded), the detail rows are expanded/unhidden for ALL sections
1-8 --- not just sections 1-4. Is there anything I can do to keep the
grouped rows from expanding if the user does not want to view that section?