Excel: Disable alert about trying to change protected cell on BeforeDoubleClick
<p>I have a worksheet that has a protected range of cells. These cells have names in them and I would like to have a before double click event that shows a form and pre-loads info in the form based on the name in the cell that is double clicked.</p>
<p>I'm using double click so the user gets the cell selected on the first click, then I can use <code>ActiveCell.Value</code> to get the name and load the appropriate information.</p>
<p>However, since I have protected the range, when I double click a cell I get an excel prompt saying</p>
<blockquote>
<p>The cell or chart that you are trying to change is protected and therefore read-only.</p>
<p>To modify a protected cell or chart, first remove protection using the Unprotect Sheet command (Review tab, Changes group). You may be prompted for a password.</p>
</blockquote>
<p>The forms still triggers as planned, but I would like to stop the excel prompt from happening. Is there a way to disable the prompt? If not, is there another way of going about this that I'm not thinking of?</p>