Lock cell question

  • Thread starter Thread starter guile
  • Start date Start date
G

guile

You protect a worksheet using the tools menu. But is there anyway yo
can lock a specific range of cells and not the entire worksheet
 
Yes

First select the whole worksheet
Format>Cells>Protection
Uncheck the locked box
Select the cells to lock
Format>Cells>Protection
Check the locked box
Protect the worksheet
 
Good morning Guile

Indeed. When you protect a worksheet only the cells that have their
properties set to "locked" are prpotected, but every new worksheet
opened has all its cells set to locked by default, so you need to
unlock the cells first. Highlight all the cells you want protecting,
then press ctrl + 1, go to protection and uncheck the locked box.
Worksheet protection will then have no effect on these cells.

HTH

DominicB
 
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

Possible to select a string in a locked cell? 1
Locking cells 3
loop through rows 1
Lock specific cell 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
protecting cell depending on value of another cell 1
Protect worksheet but still be able to use Data Filter and Data Sort 2
Excel VBA 1

Back
Top