Discussion Locked

MS Excel - Assign different passwords to different cells on same worksheet

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In MS Excel, is it possible to assign different passwords to different cells on same worksheet? The intention is to allow users to edit their own cells based on their given password. No one can access the other user's cells. The sheet protect function only uses one password to unprotect the full sheet but this does not solve my issue.
Thank you.

4 replies

by tonythetiger

You might be able to protect the entire sheet, and write a macro to unprotect certain cells based on the windows username.

by maevinn

Why not just give each person their own sheet, and then have one master sheet that picks up a specific cell from the sheet? For example, rename the sheet with their name, assign that sheet their password, and have them enter data into A1. Then you can pull A1 from each sheet and process it as needed.

by jy76

You could try the Allow Users to Edit Ranges feature. In Excel 2003, this is under the Tools, Protection menu. You can set up ranges with passwords and permissions for particular users. In Excel 2007, the feature is on the Review tab.

It may be worth looking at the "Office challenge: How would you restrict users to a specific range in an Excel sheet?" item on this site for further info.

This discussion is closed to new replies.