View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Protect Sheet but allow sorting

Debra Dalgleish has a technique that sorts a range by a certain column by
clicking on an invisible rectangle in the header.

You could add a couple of lines to that code--a line to unprotect the worksheet
near the top and a line to protect the worksheet when it's done (right near the
bottom).

http://contextures.com/xlSort02.html

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...


--

Dave Peterson