<div>
I would be happy to help you, but I don't understand your question. Can you try rephrasing it in a more clear way, and/or providing a sample file?
</div>


I would be happy to help you, but I don't understand your question. Can you try rephrasing it in a more clear way, and/or providing a sample file?

macro-enabled workbook with worksheet_change events and protected data entry

EE-Q-28500836.xlsm

<div>
FYI, you could protect the sheet in the Workbook_Open event using the UserInterfaceOnly:=True argument and then the code can clear the relevant cell(s) without needing to unprotect the sheet.
</div>


FYI, you could protect the sheet in the Workbook_Open event using the UserInterfaceOnly:=True argument and then the code can clear the relevant cell(s) without needing to unprotect the sheet.

<div>
Hi guys, thanks for your responses, Glen your code is slick, and i will be using this code again!<br />
<br />
I will repost my q as having thought it through, my requirements are slightly different, thanks!
</div>


Hi guys, thanks for your responses, Glen your code is slick, and i will be using this code again!

I will repost my q as having thought it through, my requirements are slightly different, thanks!

<div>
@Rory...I didn't know about that option (i.e., UserInterfaceOnly). &nbsp;That is very handy; thanks!
</div>


@Rory...I didn't know about that option (i.e., UserInterfaceOnly).  That is very handy; thanks!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a range of cells (B31:B59) They have drop downs of &quot;Delete&quot;, &quot;No Change&quot; or &quot;Edit&quot; <br />
<br />
<br />
If B32 Edit is selected i want K31 to be first be unlocked (password &quot;hello&quot;) and second have its contents cleared<br />
<br />
Is there some code that can achieve this for me?<br />
<br />
Thanks
</div>
</div>


Hi,

I have a range of cells (B31:B59) They have drop downs of "Delete", "No Change" or "Edit" 


If B32 Edit is selected i want K31 to be first be unlocked (password "hello") and second have its contents cleared

Is there some code that can achieve this for me?

Thanks

Unlock / clear cell if dropdown = Edit

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.