User ID to lock information

[AnnAnn]

This is my first thread so I hope I can explain my problem.

I have a spread sheet that up to 20 users fill in. They fill in one row of data at a time with settings obtained from other equipment. This is a daily record of the equipment and must be secure. I would like each user to have a unique password so that at the end of entering all the data, all the data in that row is locked by entering there own unique PW that will then show their name and number. Also if they need to re-enter the data (after it is locked) they can cancel what they have done, but it will not be erased (highlight all in RED) and simply go to the next row down. This will stop people writing over the data. Also I would need the ability to have administer wrights.

I have been trying to do this for two months but with no luck.

Ann

[AndyLitch]

Ann,

This is relatively easy but there are a number of steps each with options so we probably need to develop this in stages is that ok ?
The first option for example is would you like to block unautorised users from seeing the data ?

[AnnAnn]

I do not need to block unauthorized users seeing the data just stop unauthorised users saving it at the end. Anyone can enter data but only those with PW can save it. This is for trainees under supervision

[FDibbins]

select save-as, select tools, select general options enter a password to modify

[AndyLitch]

Attachment 224747

Anne

Have a look at the file above and see if it's the kind of thing you're looking for..
Log in as "Admin" and the password is "Admin"

Once logged in it only allows you to change your own entries in the table