Hi there,

From a search of previous posts I found the code:

activesheet.autofiltermode = false

to switch off autofilter is it has been applied. This is good but
would like to cycle round ALL sheet in the workbook and apply that lin
of code.

I tried

Sub Test
For each Sheet in ActiveWorkbook
Sheet.AutofilterMode = False
Next Sheet
End Sub

and also Sheet*s*.AutoFilterMode = False

but neither worked.

Hope somebody can help

TIA

Seamu

--
Message posted from http://www.ExcelForum.com