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