M
Minos
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
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