I want to remove Autofilter from all sheets of my workbook. No matte
whatever the ranges the sheet might have.

At present i m trying this...

Code
-------------------
For Each sh In ActiveWorkbook.Worksheets
' Open hidden sheet
If sh.Visible < xlSheetVisible Then
sh.Visible = True
sh.EnableAutoFilter = False
End If
sh.EnableAutoFilter = False
Next s
-------------------

But it does not remove for all... Please help

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=40192