View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wahamler wahamler is offline
external usenet poster
 
Posts: 2
Default How do I conditionally lock cells?

How can I make the ability to edit a cell conditional based on the value of
another cell? For example if cell A1 contains the value "Yes", cell A2 can
be edited. However if the value in A1 is "No", cell A2 should be locked.