Protecting different cells in Excel with different passwords

  • Thread starter Thread starter Monsoonmarble
  • Start date Start date
M

Monsoonmarble

Is it possible to lock different cells with different passwords in Excel? For
example I would like person A be able to unlock a cell type something then
lock it up again. Then Person B unlock another cell on the same worksheet,
type something then lock it up again. Is this possible?
 
If you are using XL 2002 or better then you can look inot Tools -> Protection
-> Allow Users to Edit Ranges...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Locked cells are still able to be selected with proper protection 1
Excel 2000 help please - Cell protection 2
How to change format protection default to unlocked? 2
corrupted formula in protected worksheet 21
protection 2
Data copy locks cell in worksheet 3
Problem tabbing between merged cells in Excel 2010 0

Back
Top