How to Sort Protected Worksheet

M

mr.lord

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?
 
D

dominicb

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
 
Top