title: Excel VBA prevent deletion of cells but allow edit
body: <p>I have made a spreadsheet which a user can enter a postcode and a quantity into 2 cells and I have other cells doing calculations and displaying the results.</p>
  
  <p>I have added some VBA to prevent anyone from deleting rows and columns but I would like to prevent deletion of any cell within a range but also allow a user to make changes to certain cells but also prevent editing of cells with formula in there.</p>
  
  <p>In cell <code>E4</code>, the user can enter a postcode. In <code>E6</code>, the user can enter a quantity. These can be edited but not deleted. <code>E8:E9</code> and <code>E11:E14</code> are all drop down lists (validation) which hold data from lists. These can be changed using the drop down but not deleted.</p>
  
  <p><code>L10:L14</code>, <code>L16</code>, <code>L23:L27</code>, <code>L29</code>, <code>L30:L33</code> can all have their data edited but not deleted.</p>
  
  <p>What would the VBA for this look like? I guess it would use the <code>Worksheet_Change() event</code>.</p>