Locking cells

  • Thread starter Thread starter Dave Elenor
  • Start date Start date
D

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
 
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
 
Back
Top