Thread: Restrict users from changing to certain values in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphinv4 Dolphinv4 is offline
external usenet poster
  
Posts: 27
Default 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
Reply With QuoteReply With Quote