nitinkrjain
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
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
There is no facility in Excel to to this
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
Thanks for your help.
Can we take password on sheet to Approve the row, or edit the row.
Plz advise
Thanks again
Nitin