Switching custom view when filtered
 

I have a very large spreadsheet that I navigate using custom views. I change
views using macros because I have a couple of other commands that I want
executed as well. I also commonly filter the rows of the spreadsheet.
However, when I switch views, the filter is turned off, and I would like it
to remain filtered as is. Is there a way to stop the filtering from being
turned off? Or can I get the filter setting with a VB command and then
reapply it at the end of the macro? Thanks!

Switching custom view when filtered
 

correction - I filter a particular column, not rows, hiding the rows that
don't meet the criteria. :-)

"tsbarr" wrote:

I have a very large spreadsheet that I navigate using custom views. I change
views using macros because I have a couple of other commands that I want
executed as well. I also commonly filter the rows of the spreadsheet.
However, when I switch views, the filter is turned off, and I would like it
to remain filtered as is. Is there a way to stop the filtering from being
turned off? Or can I get the filter setting with a VB command and then
reapply it at the end of the macro? Thanks!