Sorting not allowed when cells are protected

[John]

I want to protect cell formulas from being deleted yet
allow others to sort the results. If I protect the cells'
contents, sorting is greyed out & not available.
How can I protect cells yet allow rows of cells to be
sorted by others?
Specifically, I have peoples names in column A, Total
correct in column B, answers to questions in columns C
thru H. The correct answers are at the bottom of columns C
thru H. A countif formula is in each row of column B
(total correct). Sorting the results is only available if
I unprotect the worksheet thus allowing the formulas in
column B to be tampered with.
How can I solve or get around this problem???? HELP???

 

[Ron de Bruin]

If you use Excel 2002 you can protect a sheet and be able to sort.

For other versions :

If you sort with a macro there is a way John

Sheets("Sheet1").Protect Password:="hi", userinterfaceonly:=True
When you run this line your sheet is protect for the user but macros are working

This code must be run everytime you open the workbook.
A good place is the workbook open event