Thread: Use autofilter with macro in a protected sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Minos Minos is offline
external usenet poster
  
Posts: 3
Default Use autofilter with macro in a protected sheet
Hi,

I have a protected worksheet with the option of €śUse Autofilter€ť enabled.
I have a macro that runs a filter for selected records. I have a second macro
(see below) that removes the previous filter.

ActiveSheet.Unprotect
Selection.AutoFilter Field:=20
ActiveSheet.Protect

End Sub

How can I again enable the €śUse Autofilter€ť together with the €śActive
Sheet.Protect€ť command.

Thanks

Minos

Reply With QuoteReply With Quote