View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
 
Posts: 89
Default Conditional Proctection?

Is it possible to lock/unlock cells based on another cell value?

If cell = "text1" unlock cells A4:B4 and lock cells C4:D4 If cell = "text2"
unlock cells C4:D4 and lock cells A4:B4

The text1, text2 are from a combo box drop down list located on another
worksheet

Thanks