Locking certain parts of a spreadsheet

J

Joey

Hi all

Is it possible to lock certain parts of a worksheet or lock a workshee
and allow access to certain cells in it?

Many thanks
Joe
 
F

Frank Kabel

Hi
try the following:
- first select all cells for which you want to allow entries
- goto 'Format - Cells - Protection' and uncheck 'Locked'
- After this protect your worksheet ('Tools - Protection')
 
Top