lock record / row to prevent mixup

A

ariepenarie

hi!

i would like to lock my records to prevent someone from sorting the
indivual cells (instead of the complete records / row). i don't want to
protect the whole file, since several people are working on it.

i know how to sort complete records, it's just that i want to build in
a safety.

thanks in advance!
 
F

Frank Kabel

Hi
you can't do this. One workaround:
- protect the sheet
- create a macro that first unprotects the sheet, sorts the data and
protects the sheet again
- use this macro
 
Top