How to Sort Protected Worksheet
 

I have a protected worksheet and I am trying to allow sorting and formating,
but not deleting or inserting. It does not work the way it should. Does
anyone know the trick? I know about give a range of to edit, but how can I
allow users to sort the data without being able to corrupt the data?

Good morning MrLord

Why not have a "sort" button on the worksheet that is linked to a
macro. The macro (which should be easy enough to record) will
unprotect the sheet, sort the data and then reprotect the sheet again.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=374260