Thread: Locking/Unlocking based on another cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Iriemon Iriemon is offline
external usenet poster
  
Posts: 89
Default Locking/Unlocking based on another cell value
I need to be able to lock/unlock certain cells based on the value contained
in another cell:

Cell A1="yes" - unlock B1 and lock C1
Cell A1="no" - lock B1 and unlock C1

Any help is greatly appreciated.

J
Reply With QuoteReply With Quote