Link to home
Start Free TrialLog in
Avatar of nitinkrjain
nitinkrjainFlag for India

asked on

Password protected row wise data entry - in excel 2010

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.

Thanks
Sameple-Sheet.xlsx
Avatar of Brian Pierce
Brian Pierce
Flag of United Kingdom of Great Britain and Northern Ireland image

There is no facility in Excel to to this
ASKER CERTIFIED SOLUTION
Avatar of Elton Pascua
Elton Pascua
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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!!

Thanks
Rob H
Avatar of nitinkrjain

ASKER

hi techfanatic

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

Plz advise

Thanks again
Nitin