If you mean turn off any autofilters:

Private Sub Workbook_Open()
for each sh
sh.AutofilterMode = False
Next
End Sub

--
Regards,
Tom Ogilvy

"sal21 " wrote in message
...
in auto open wbook, unselect filtre if is presentt in all sheets...


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