tags:

views:

13

answers:

0
Q: 

Keep rows hidden even when a table filter option is selected in Excel2007

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....

related questions

Table Column Formatting
How do you truncate all tables in a database using TSQL?
how to see the schema of a db2 table (file)
Tools for refactoring table-based HTML layouts to CSS?
Page working in FF, not in IE, where to start
Hiding table rows without resizing overall width...
DIV with overflow:auto and a 100% wide table problem
For tabular data, what renders faster, CSS or <TABLE>?
I need my html table's body to scroll and its head to stay put
How to line up items of varied length in a resizable space in CSS?
CSS to make a table column take up as much room as possible, and other cols as little
Best approach for sortable table with a lot of data
A more advanced table/spreadsheet SWT implementation
JSF how do I retrieve the selected rows of a woodstock table
How to scroll only the right side of a table, listview, or datagrid?
Make a div fill the remaining screen space
How to stretch an HTML table to 100% of the browser window height?
SqlServer create table with MySql like auto_increment primary key
Why not use tables for layout in HTML?
Should Tables be avoided in HTML at any cost?
HTML drag and drop sortable tables
CSS overflow table row positioning
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Configurable Table Prefixes with a .Net OR/M?
SQL Table Aliases - Good or Bad?