nithin shettigar
New Member
- Joined
- Mar 16, 2014
- Messages
- 44
Please help me out with my issue.
In my excel sheet were I want to lock cell range L1: L1000.Only after double click on L1: L1000 row user form for password should popup.
After entering password L1: L1000 should be editable. If Ienter “OK” I any were between L1:L1000 then the whole Colum should be freeze (Eg: If I enter “ok” in “L7” then A7:L7 should be freeze or non-editable)
In my excel sheet were I want to lock cell range L1: L1000.Only after double click on L1: L1000 row user form for password should popup.
After entering password L1: L1000 should be editable. If Ienter “OK” I any were between L1:L1000 then the whole Colum should be freeze (Eg: If I enter “ok” in “L7” then A7:L7 should be freeze or non-editable)
