Thanks for the reply. Can you put your statements in code format so I can see
exactly what you are talking about? I have tried to use
Range("a1:aa10000").locked=false and this did not work. as a matter of fact
it all it did was allow the user to write in the cells. Which I do not want
them to be able to do. I do not understand why the sort ascending and
descending options are not allowed? I have set the allowsorting and
allowfiltering to true when protecting the sheet from my macro, so why can't
the user sort using the Ascending or Descending options in the drop down box
of the autofilter?

"Allllen" wrote:

Before protecting the sheet, ensure none of the cells in the range you want
to filter are locked. Then it should work.
--
If you found this post helpful, please click "Yes".
Allllen


"statum" wrote:

I am trying to figure out how to allow a user to use the sort ascending and
sort descending options that are displayed when the user clicks the drop down
icon in a autofiltered cell. The other options (all, custom, etc..) work just
fine. I am only having trouble "turning" on the ascending and descending sort
options. Not that the worksheet is protected. Here is an excerpt of my
code.....thanks in advance for the help! Note that AutoFiltering is turned
on....
sub Workbook_Open()
Sheets("WORKLOG").Unprotect
.
.
.
do stuff.....
.
.
ActiveSheet.Protect DrawingObjects:=False, Contents:=True, Scenarios:= _
False, AllowSorting:=True, AllowFiltering:=True,
AllowUsingPivotTables:=True
end sub