Locking cells

[Dave Elenor]

Can I lock different cells

say A2 A4 A6 after that open and close workbook anytime and never have to
unlock them, and still be able to use all other cells in the workbook

 

[Gord Dibben]

Dave

By default all cells are locked when the sheet is protected.

Hit CRTL + A(twice if xl2003) then Format>Cells>Protection. Uncheck "locked"
and OK.

Select the cells you wish to lock and Format>Cells>Protection. Check "locked"
and OK.

Now Tools>Protection>Protect Sheet. Save the workbook.


Gord Dibben Excel MVP