View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default locking the cells

Format/ Cells/ Protection/ unselect Locked, for those cells that you still
wish to be able to write into.
Then Tools/ Protection/ Protect worksheet
--
David Biddulph

"Rajesh Chandra" wrote in message
...
How can i lock the cells with formulas so that no one can edit that cell
either by writing in that cell or by any other means. Some people write in
the cells with formulas and after that formulas disappear and only their
text
remains.Please help a.s.ap.
--


Rajesh Chandra