Hi
I use row groupings extensively (2 levels only). I also have hidden rows which will always reappear if row level 2 is clicked on.
To overcome this, I store the row numbers that I want permanently hidden (I do not want to delete them) in a table and I have a macro that will re-hide those rows stored in the table.
I would like to automatically run the macro every time after the row selection is expanded so that they get re-hidden. Perhaps as a worksheet change event but not for every change, only when the rows are expanded
Any suggestions?
Thank you
I use row groupings extensively (2 levels only). I also have hidden rows which will always reappear if row level 2 is clicked on.
To overcome this, I store the row numbers that I want permanently hidden (I do not want to delete them) in a table and I have a macro that will re-hide those rows stored in the table.
I would like to automatically run the macro every time after the row selection is expanded so that they get re-hidden. Perhaps as a worksheet change event but not for every change, only when the rows are expanded
Any suggestions?
Thank you