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?
Bookmarks