sathishsusa
New Member
- Joined
- Dec 7, 2016
- Messages
- 30
Hi guys,
i want to Lock and unlock the cell by selecting the option of drop down list 1. lockcell and 2. unlock cell.
Eg:-
"A1" i have a drop down list to select items.
"B1" i have a drop down option selecting 1. lock cell 2.unlock cell ( after selecting list in "A1" i want to select the option 1. lock cell and i can't edit the cell "A1" unless selecting option 2. unlock cell to release cell to edit).
is there any formula to use to Lock and unlock the cells....
i want to Lock and unlock the cell by selecting the option of drop down list 1. lockcell and 2. unlock cell.
Eg:-
"A1" i have a drop down list to select items.
"B1" i have a drop down option selecting 1. lock cell 2.unlock cell ( after selecting list in "A1" i want to select the option 1. lock cell and i can't edit the cell "A1" unless selecting option 2. unlock cell to release cell to edit).
is there any formula to use to Lock and unlock the cells....