Solved: Protect and Specify to Allow Autofilter

[belly0fdesir]

Forgive me, for I am in the very early learning stages of VBA...


Is there a way in Excel 2003,to have a macro protect your sheets, but specify to allow Autofilter?

[Jacob Hilderbrand]

Try this.


Sheets("Sheet1").Protect DrawingObjects:=True, Contents:=True, _
Scenarios:=True, AllowFiltering:=True

[belly0fdesir]

Worked perfectly. Thank you very much!

[Jacob Hilderbrand]

You're Welcome :beerchug:

Take Care