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.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column = 6 Then
Cancel = True

ActiveSheet.Unprotect

UserForm1.show
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?