| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DropDown List and Cell Lock
Hi,
I have found that even though all the cell in specifc column is locked, if the column can select value from a value list, the cell value can still be chnaged. Do anyone know how to prevent it? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown List and Cell Lock
Remove the Data Validation if you don't want to use it.
-- Regards, Tom Ogilvy "KI LEE" wrote in message ... Hi, I have found that even though all the cell in specifc column is locked, if the column can select value from a value list, the cell value can still be chnaged. Do anyone know how to prevent it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return value from a dropdown list in other cell | Excel Discussion (Misc queries) | |||
| VLookUp and DropDown List in the same cell | Excel Worksheet Functions | |||
| How do you lock a cell after making a selection from a dropdown b | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Linear Mode
