Password protected row wise data entry - in excel 2010

Posted on 2012-08-20
Last Modified: 2013-01-05
We want a excel sheet which contains some data row wise, there are different person for data entry & auditing.
We want once the data is audited by auditor, he can lock the row by entering password.

Please advise how to do that.

Attached sample sheet.

Question by:nitinkrjain
    LVL 70

    Expert Comment

    There is no facility in Excel to to this
    LVL 8

    Accepted Solution

    Here's an approach which hopefully, you can build on. Make sure to change the XXXXX to your username on the computer.
    LVL 31

    Expert Comment

    by:Rob Henson
    Well actually, strictly speaking there is a facility available.

    You can protect the worksheet and allow certain users to edit certain ranges. Not sure where to find in Excel 2010 but in Excel 2003 it is in the Tools menu, Protection submenu > Allow users to Edit ranges.

    I haven't actually used it myself!!

    Rob H
    LVL 1

    Author Comment

    hi techfanatic

    Thanks for your help.
    Can we take password on sheet to Approve the row, or edit the row.

    Plz advise

    Thanks again

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    Outlook Free & Paid Tools
    This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now