Help required in VBA

[nithin shettigar]

In my excel sheet were I want to lock cell range L1: L1000.Only after double click on L1: L1000 , user form for password should popup.
After entering password L1: L1000 should be editable. If I enter “OK” In any were between L1:L1000 then the whole Rows should be freeze (Eg: If I enter “ok” in “L7” then A7:L7 should be freeze or non-editable)

 

[MARK858]

Duplicate of https://www.mrexcel.com/forum/excel-questions/1083551-vba-help.html#post5206422

 

[Fluff]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.