Protect Data, but allow sorting
 

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete

Protect Data, but allow sorting
 

Make sure that there's an empty column between the range to be sorted and any
"adjacent" data.

If you have a locked cell butting up to the range to be sorted, excel yells!



Pete Walburn wrote:

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete

--

Dave Peterson

Protect Data, but allow sorting
 

Dave,

I'm afraid that even with no data in any adjacent cells, I get the same
problem.

I need to have the cells protected, so that the data cannot be changed, but
allow the column to be sorted.

Pete


"Dave Peterson" wrote:

Make sure that there's an empty column between the range to be sorted and any
"adjacent" data.

If you have a locked cell butting up to the range to be sorted, excel yells!



Pete Walburn wrote:

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete

--

Dave Peterson

Protect Data, but allow sorting
 

Oh, the cells need to be unlocked in that range to sort.

I think I'd do what was suggested in your other thread if you have to have the
cells locked.



Pete Walburn wrote:

Dave,

I'm afraid that even with no data in any adjacent cells, I get the same
problem.

I need to have the cells protected, so that the data cannot be changed, but
allow the column to be sorted.

Pete

"Dave Peterson" wrote:

Make sure that there's an empty column between the range to be sorted and any
"adjacent" data.

If you have a locked cell butting up to the range to be sorted, excel yells!



Pete Walburn wrote:

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete

--

Dave Peterson


--

Dave Peterson

Protect Data, but allow sorting
 

Hi,

I have had similar instances, and have got round it by writing a macro to do
the sort, and making themacro available on a menu/button or control key
sequence.

HRman

"Pete Walburn" wrote:

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete