Hi,
I've been browsing the forum and found a similar concern but didn't get any result.
i have a macro that locks my worksheets yet it Enables AutoFilter for all the sheets with filtering.
when testing the worksheets - it allows me to use the Filter.
but after re-launching the excel file -- the filter button is there but it won't allow me to click on it.
my sheets are still locked like i wanted it but the autofilter fails.
Below is the code i used --- dragged and tracked around the web
Public Sub lock1()
For a = 1 To Sheets.Count
With Sheets(a)
.Protect Password:="password", DrawingObjects:=True, _
contents:=True, Scenarios:=True, _
UserInterfaceOnly:=True
.EnableAutoFilter = True
End With
Next
End Sub
Thank you in advance,
Bookmarks