title: Data not maintaining on editing an unlocked cell in proteced sheet
body: <p>I have a problem with editing a unlocked cell in a protected sheet.</p>
  
  <p>When i double click on an unlocked cell in proctected sheet the data in the particular cell dissapears.if i have a text about 200 characters and like to edit it by double clicking the particular cell the whole data dissapears then the i have type the whole data with corrections.Please help.i even tried hidden = false for the particular cell but i found no luck.Please help.</p>
  
  <p>My code:</p>
  
  <pre><code>ActiveSheetUnprotect "excel"
  ActiveSheet.Cells.Locked = False
  ActiveSheet.Range("a1:br42").Locked = True
  ActiveSheet.Range("e1:e37").Locked = False
  ActiveSheet.Range("e1:e37").Hidden = False
  ActiveSheet.Range("a1:br42").FormulaHidden = True
  ActiveSheet.Protect "excel"
  </code></pre>