title: Enable Macro in Protected Worksheet
body: <p>I wrote a code for the worksheet, and everytime I change a number, if the varaince is greater than by 10%, 20%, or +20% it changes color. So i've used macro code on both "General" and "Private Sub Selection_Worksheet" so that everytime the cell's number changes, it would change the color. </p>
  
  <p>I've locked and hidden some of the cells that show formulas,and wrote a code</p>
  
  <pre><code>    Sheets("Financials").Protect Password:="Ottawa", UserInterFaceOnly:=True
  </code></pre>
  
  <p>on both General and "Private Sub Selection_Worksheet" and it gives me a runtime error everytime i click on any cell.</p>
  
  <p>How do I solve this issue? I only want them to use certain cells and still run the macro while being protected and hidden.</p>
  
  <p>Thanks,</p>
  
  <p>Daniel </p>