lock cells

  • Thread starter Thread starter John R
  • Start date Start date
J

John R

Can you lock individual cells whereby it takes a different password to unlock
each individually locked cell?
 
Tools>Protection>Allow Users to Edit Ranges.

Each range which can be a single cell can have its own password.


Gord Dibben MS Excel MVP
 
Hi Gordon,
Jumping in...
I have XL2000 - don't seem to have the 'Allow Users to Edit Ranges' in my
protection options. Am I missing something, or is that a feature of later
versions?
Regards - Dave.
 
I skipped XL2000 when I went from 97 to 2002 so can't speak to that question but
probably came in with 2002 version along with some other new features for
protecting worksheets.

Keep eye on this, someone will drop in with an answer.


Gord
 
Added in xl2002.


Hi Gordon,
Jumping in...
I have XL2000 - don't seem to have the 'Allow Users to Edit Ranges' in my
protection options. Am I missing something, or is that a feature of later
versions?
Regards - Dave.
Click to expand...
 

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

Multi worksheet protection & editing ability 6
I can still select & manipulate locked & protected cells in '07 1
Locking all but a few cells on a worksheet 3
Conditional Proctection? 1
Tab Key 1
Locked cells 1
Why is AutoSum iinoperable w/protection when column is unlocked? 2
Viewing of protected locked or unlocked cells 2

Back
Top