I have an Excel worksheet in which several rows are grouped together using Group and Outline.
By default, the group should be expanded, but I have one line that I hid using vba in Workbook_Open.
After I click [-] to collapse the group and then [+] to expand it, now my hidden line is now visible.
Is there a way to keep the hidden row hidden even after the group is minimized and expanded again? Or is there a way to capture the event so that I can use vba to hide the row every time the group expands?
source
share