AutoFilter Enable

[JyothiGrace]

I have a macro that protects and unprotects sheets. I realized that once I protect, default only gives users option to select any given cell. I would like them to also use the autofilter option. What is a code to activate "Use AutoFilter" before sheet gets protected? So far this is what I have but it is not working:

Sub wsProtect()

Sheet1.EnableAutoFilter = True
Sheet1.Protect "1234"

End Sub

[ORoos]

Hi there,

Try:

Please Login or Register  to view this content.