Locking certain parts of a spreadsheet

[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

 

[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')

 

[Joey]

Sweet...!

Thanks Fran