| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restoring Filter
In VBA, how can I restore filter before saving.I need a code by which
unfilter all the worksheet(if they are in filter mode)and then save the workbook? thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Restoring Filter
You can just do:
Selection.AutoFilter This will get rid of the filter pull-downs and restore any rows hidden by the filter. However, if you don't have any filters on the sheet, this will set them up. Hope this helps. Pete On Oct 26, 12:30 am, peyman wrote: In VBA, how can I restore filter before saving.I need a code by which unfilter all the worksheet(if they are in filter mode)and then save the workbook? thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Watch Windows - restoring to floating | Excel Discussion (Misc queries) | |||
| Restoring Worksheet | Excel Discussion (Misc queries) | |||
| Restoring toolbar | New Users to Excel | |||
| Restoring the File option on the top Menu bar of Excel. | Excel Discussion (Misc queries) | |||
| Restoring fields in a pivot table | Excel Worksheet Functions | |||
Hybrid Mode
