| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Switching view on/off for row & column headers? | Excel Discussion (Misc queries) | |||
| View Custom View with Sheet Protection | New Users to Excel | |||
| How do i view only the filtered results from autofilter ? | Excel Discussion (Misc queries) | |||
| How to view a custom view when the worksheet is protected? | Excel Worksheet Functions | |||
| Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
Linear Mode
