"Locking" the sheet to prevent mixing up data

F

fred

Hello,
I wonder if there is a way to prevent user from sorting one
column only, leaving other columns intact.
Ideally, I am looking for the method of "locking" the sheet that way, that
whatever user does to the sheet's columns the data in other columns will be
always related to the original data in that column.
I am writing this, because I had the hard experience with the user who made
a selection of one column data and then sorted it using 'Sort' by Date but
it applied that operation to that particular column only.
As result all data get mixed up, rendering the database useless.
Thanks,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top