Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Group function with hidden rows
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem using group function with hidden rows | Excel Programming | |||
opening a group but keep hidden rows hidden | Excel Discussion (Misc queries) | |||
Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
Sum function which ignores hidden rows | Excel Worksheet Functions | |||
Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) |