• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lock cells as you type

samantha

New Member
Hello Everyone,
Just a question: I had a project and had a few data entry clerks entering data on my spreadsheet—only to find out they have been "stealing" someone else's entries by changing the captured row to their names.
So I was thinking, is it possible if someone captures in a cell and they move off that cell? Can that cell lock, and if we need to make changes, a password is used to unlock that cell only then it can be locked again?

And I remember before we could have multiple people capturing on one Excel spreadsheet—can this be done again? If so, please advise how I can do this.

or if someone can give me advise as to how I can set up the spreadsheet so that people dont steal lines and capture at the same time?

Thanking you in advance
 
Back
Top