I'm using Excel 2004 for Macintosh. I think it's equivalent to Excel 2003
for PC.

Unfortunately, there is no such option for me. Are there any Visual Basic
option that I can go about to set this up?

It just seems so restricted to set this up in Excel, but that's all we have.

Thanks for any help.
GU

"John Bundy" wrote:

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