View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
HRman
 
Posts: n/a
Default 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