title: How to create "lock" (stop updating of cells) in Excel?
body: <p>My question is pretty simple, but one to which I can't really find a solution myself. I use Excel quite frequently, but rarely the fancy stuff. Anyway, to the point:</p>
  
  <p>How do I create a dropmenu that will lock certain cells, rows or columns?
  (by lock I mean unable to change via hand and stops updating itself).</p>
  
  <p>Example: <strong>A1</strong> = 5, <strong>B1</strong> = A1 * 100, <strong>C1</strong> = A1 * 100</p>
  
  <p>Can I "lock" the B1-cell, so that changing A1 will have no effect on B1 (Will remain at value 500), but will normally affect C1-cell (will update and calculate new value)?</p>
  
  <p>I would preferably want to be able to "unlock" the cell as well, instead of simply making function into value.</p>
  
  <p>Is this possible?</p>
  
  <p>Thanks in advance!</p>