Protect worksheet and still allow user to sort data

[Guest]

I need to protect a worksheet and still have the user be able to sort data by
column. I have tried using the "Unlock" feature in the Format
Cells-->Protection dialog box but it doesn't make a difference. Once you
protect, you can't sort. Ideas?

 

[Guest]

You have to unlock ALL the cells which will be sorted. Then protect the
sheet. In the Protect Sheet dialog, make sure Select Unlocked Cells, and Sort
have checkmarks. If Select Locked Cells is checked, uesrs can select those
cells but not change them. They will be able to sort (and change) the
unlocked cells.

Hope this helps,

Hutch

 

[Guest]

Thanks... However, I don't have a "Protect Sheet" dialog-- when I go to
protect it says "Protect sheet for: contents, objects, scenarios" I can
check those options, but that's it. I saw online that in the Windows version
you can check all sorts of other options, but I am using Mac OS X and Excel
2004 and I'm wondering if that's the problem. For Mac users out there, is
there a way to get to that same dialog a different way?

 

[Desert Piranha]

Thanks... However, I don't have a "Protect Sheet" dialog-- when I go to
protect it says "Protect sheet for: contents, objects, scenarios" I
can
check those options, but that's it. I saw online that in the Windows
version
you can check all sorts of other options, but I am using Mac OS X and
Excel
2004 and I'm wondering if that's the problem. For Mac users out there,
is
there a way to get to that same dialog a different way?

I don't have all that stuff in xl2000 for windows either. You can
however highlight the cells
which you want unlocked, then right click and choose "Format Cells >
Protection".
There you can untick the "Locked" thingy.

Then when you protect the worksheet, those cells will not be locked.