Keep rows hidden even when a table filter option is selected in Excel2007
- by Srin
I have a Excel Table (Range formatted as table)
I have some rows set as Hidden in the table. the table header have filter option and when i select a filter item, the hidden rows are becoming visibe.
Is there any option / vba method to keep the hidden rows hidden ?
Ideas pls....