I am familiar with the custom views feature in Excel 2007. Is there a way to
cause rows or columns to automatically be hidden or displayed based on values
in row 1 or column A? For example, is there a way to select a custom view and
show only those columns where row 1 = "show this column" as opposed to
selecting each column and hiding it and then saving as a custom view. I have
a spreadsheet with many columns and likely, many custom views and I am
looking for a way to automate this.

Thanks in advance,
bmac