General discussion

Locked

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

By tammytn ·
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.

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Maybe

by TonytheTiger In reply to MS Excel - Assign differe ...

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

Collapse -

Macro script?

by tammytn In reply to Maybe

Great idea! Where can I find that sample of macro script please?

Collapse -

Multiple sheets?

by Maevinn In reply to Macro script?

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.

Collapse -

Allow Users to Edit Ranges

by jy76 In reply to MS Excel - Assign differe ...

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.

Back to Windows Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums