Lock spreadsheet but can sort

[Neon520]

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

 

[John Bundy]

What version of xl? my 2003 has a checkbox where you select protect that
allows you to check 'sort'

 

[Gord Dibben]

But you can only sort a contiguous unlocked range of cells so is very limited


Gord Dibben MS Excel MVP

 

[Neon520]

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

 

[Gord Dibben]

ActiveSheet.Unprotect Password:="justme"

'do your sorting by code

ActiveSheet.Protect Password:="justme"


Gord Dibben MS Excel MVP

 

[Neon520]

Thanks for everyone's help. I try but it doesn't work.

 

[Gord Dibben]

"it doesn't work" means what?

No sorting? Post your sorting code.

Incorrect sorting? Post your sorting code.


Gord