Thread: Lock cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default Lock cell

All cells are locked by default. The procedure is
1 Unlock the cells where input IS allowed, with Format Cells menu,
Protection tab,
and then
2 Protect the workcheet with Tools Protection Protect worksheet menu.

HTH. Best wishes Harald

"Mohamed" skrev i melding
...
How to lock a cell which contains a formula