View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Protect Sheet but allow sorting

If you are using XL2002 or better then when you protect the sheet there is a
set of options specifying what the user is and is not allowed to do. Sort is
one of the options. Otherwise you are stuck with Code. One thing you can do
in code relatively easily is to unprotect the sheet if the cursor is within a
specific group of cells. By doing this if the user is in the header row then
you unprotect allowing the sort. otherwise if they are anywhere else then the
sheet is protected. If that appeals to you then let me know...
--
HTH...

Jim Thomlinson


"LucyK" wrote:

Don't tell me I have to be a prorammer to protect my sheet but allow
for sorting!!! That will kill me and take days.

I have a workbook with 2 worksheets (tabs) that I would like to protect
from editing, but would like to allow for sorting.

HELP...