Thread: Use AutoFilter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rafi Rafi is offline
external usenet poster
 
Posts: 27
Default Use AutoFilter

I have a protected sheet and would like the on Open event to enable the use
of Autofilters however, my code produces the following resullt

......
For Each ws In Worksheets
ws.AutoFilterMode = True
Next

Run-Time Error 1004, Application defined or object defined error

Thanks