Protect worksheet and still allow user to sort data
 

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?

Protect worksheet and still allow user to sort data
 

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

"J9" wrote:

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?

Protect worksheet and still allow user to sort data
 

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?

"Tom Hutchins" wrote:

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

"J9" wrote:

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?

Protect worksheet and still allow user to sort data
 

J9 Wrote:
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?

"Tom Hutchins" wrote:

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

"J9" wrote:

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?Hi j9,

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.


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=563843