View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kari J Keinonen[_2_] Kari J Keinonen[_2_] is offline
external usenet poster
 
Posts: 20
Default Enable Auto Filters in protected sheet

Hi Gordon!

I think you can try next idea.

Sub ProtectAndUnprotect()
' if you unprotect you sheet
Sheets("OwnSheet").Unprotect "YourPassword"

' you autofilter code (you can recorded that)

' end of you program
Sheets("OwnSheet").Protect "YourPassword"
End Sub

Regards,
Kari J Keinonen