Protect/Unprotect Cell Range on "Double-Click"

Greetings all,

I have a sheet that drives a userform when double clicking on any cell in column "F". The sheet is in "protected" mode, with cells L4:L100 locked. All other cells can be selected.

Please Login or Register  to view this content.

What I need to be able to do is unlock cells L4:L100 temporarily while the userform is displayed to allow the results of the form to populate in column "L". Once populated, I will re-lock these cells to prevent users from modifying their content.

When executing the above code, the userform no lo longer gets displayed after making the double-click.


Any thoughts?

Thanks for the response John. However, I think I left out an important detail that is making this fix complicated-

The cells that I am performing the "double click" on are data validation cells with a drop down list. For whatever reason, the code you provided does not execute properly when double clicking on a cell with data validation.