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
|