title: Protect excel sheet with some exceptions
body: <p>I have a excel sheet in which I am using macros, dropdowns and buttons. I have also got a lot of formulas in different cells like multiplication, vlookup etc. The buttons work in such a way that when I press it adds a empty row and adds some data to it. There are few cells in which the user is supposed to enter the data </p>
  
  <p>Buttons, formulae and dropdowns change  and add new data to different cells</p>
  
  <p>Now I want to protect the sheet so that the user can't change the content by mistake or intentionally.</p>
  
  <p>But when I protect the sheet its shows error on using the sheet because buttons, multiplication and vlookup tend to change the data in different cells all the time.</p>
  
  <p>Is it possible to make the sheet read only for the user (except for some cells where is supposed to enter the data) and  allow macros, formulae and dropdowns to change the cell content</p>