Thread: protect a cell based on values in range
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_390_] Leith Ross[_390_] is offline
external usenet poster
  
Posts: 1
Default protect a cell based on values in range

Hello JeKaRe,

Data validation is a convenient tool but lacks the protrection featur
you want. To prevent the user from changing the list once the have mad
a selection would involve writing a VBA macro. To write the macro woul
require more details about how your application is setup.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=49426

Reply With QuoteReply With Quote