View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kristin Kristin is offline
external usenet poster
 
Posts: 43
Default Protect Sheet: clicking in cells removes all previous text

I protected a sheet because I have formulas on the sheet. So, I locked those
cells and left the rest of the cells unlocked. When the sheet is protected,
if I click in a cell and try to add text to the cell, it deletes all the
previous text. Is there any way to stop that from happening?