Locking cells

  • Thread starter Thread starter TO
  • Start date Start date
T

TO

Hello All,

I have created a workbook that populates cells based on
user inputs. I would like to allow the user only to
input in specific cells and lock all others. Can this be
done?

Thanks
 
Hi
try
- select all cells for which you want to allow entries
- goto 'Format - Cells - Protection' and uncheck 'locked' for these
cells
- goto 'Tools -Protection' and protect your worksheet
 
high light all the cells that you want users to have
access to, then go to fomat/cells/protection tab and
uncheck the "locked", that should do it.
 
TO,

i do not know if you are looking for a simplistic solution as the one
have used.

the cells that i do not want edited by others, i select them. righ
click, select Format Cells. click on Protection tab and check Locked.

then i go to Tools - Protection and protect the worksheet with
password.

you can do all this with a macro, but its quite simply done this way
 
Back
Top