What version of xl? my 2003 has a checkbox where you select protect that
allows you to check 'sort'
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Neon520" wrote:

I am working on a template. I'd like to lock my spreadsheet so others who
use this template can't change the formula inside, but I'd like to make the
sorting feature available. Is there a way to do this?

When I go to Tool Protection Protect Sheet, it also disable the sorting
feature in Excel.

Any help or advice?

Thanks,
GU