------ Register to get rid of these "In Post" ads! ------


Hello,

I have have a Tabel that uses the Auto Filter option, i secured my Sheet with:
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False, AllowSorting:=True, AllowFiltering:=True

on opening of the document.

when I click on the AutoFilter button to Sort Accending it gives me an error
'Original Source: The Code Cage Forums http://www.thecodecage.com/forumz/excel-vba-programming/105734-protection-auto-filter.html#post377836
message "The cell or chart you are trying to change is protected and
therefore read-only"

How can i have the fields protected but let it sort?

thank you,

Daniel Schmidt