ExcelBanter - DropDown List and Cell Lock

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - DropDown List and Cell Lock (https://www.excelbanter.com/excel-programming/314251-dropdown-list-cell-lock.html)

KI LEE

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?

Tom Ogilvy

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?

All times are GMT +1. The time now is 07:48 AM.