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