ExcelBanter - Restrict users from changing to certain values in a cell

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Restrict users from changing to certain values in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/187202-restrict-users-changing-certain-values-cell.html)

Dolphinv4

Restrict users from changing to certain values in a cell

Hi,

I have a row whereby it'll do a vlookup and show the values 10,11,12 or 34.
users are not supposed to change anything if the cells show 10,11 or 12.
However, they can change if it shows 34, but changing it to 12 ONLY.

How can I get that effect using macro?

Thanks.
Dolphin

All times are GMT +1. The time now is 08:22 PM.