Password protect cells in Excel

Is there a way to password protect cells in a column?  What I'm looking for is for the user to be prompted to enter a password before being able to enter data in a particular cell.
dbfromnewjerseyAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
You cannot password protect specific cells but you can password protect a sheet.

The sheet can be set to have locked or unlocked cells; only the unlocked cells will be editable when the sheet is protected. To edit the locked cells the user would have to unprotect the sheet (with the password) and then edit the cell and re-protect the sheet.

I guess this would be possible by using a VBA routine that asks for the user entry with an input box and confirmation with a password entry box. The password would then be checked against something and if correct the change is made.
0
 
Roy CoxGroup Finance ManagerCommented:
That's WorkSheet Protection available from the Review Tab of the Ribbon. Here's a more detailed explanation

Protect a worksheet
0
 
dbfromnewjerseyAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.