View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dinesh Dinesh is offline
external usenet poster
 
Posts: 103
Default Lock the cell once enter the data

Hi,

I sthere anyway can you lock and unlock the cell once you enter the data?

For example : If enter "Yes" to an greement on Cell C50. I want to lock the
cell, so nobody can change the answer except myself. I am sure we can use
helper cell to create somekind of formula which I am not sure what it is?

Thanks to advise

Dinesh