Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 454
  • Last Modified:

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
0
nitinkrjain
Asked:
nitinkrjain
1 Solution
 
KCTSCommented:
There is no facility in Excel to to this
0
 
Elton PascuaCommented:
Here's an approach which hopefully, you can build on. Make sure to change the XXXXX to your username on the computer.
sample-sheet-auditor.xlsm
0
 
Rob HensonIT & Database AssistantCommented:
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
0
 
nitinkrjainAuthor Commented:
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
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now