| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error on auto filter
This should be a quick fix. I want to re-set the autofilter to show all on
workbook open. Problem is when it's already set to show all I get an error msg. Private Sub Workbook_Open() '=============== 'reset filter '=============== Application.ScreenUpdating = False ActiveSheet.ShowAllData End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Error on auto filter
Try adding this
on error resume next ActiveSheet.ShowAllData on error goto 0 "Rominall" wrote: This should be a quick fix. I want to re-set the autofilter to show all on workbook open. Problem is when it's already set to show all I get an error msg. Private Sub Workbook_Open() '=============== 'reset filter '=============== Application.ScreenUpdating = False ActiveSheet.ShowAllData End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| auto filter with error value | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Linear Mode
