lock record / row to prevent mixup

[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!

 

[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

 

[ariepenarie]

thanx