View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ridhi Ridhi is offline
external usenet poster
 
Posts: 22
Default Formula/Function to lock and unlock a cell in excel

I am trying to lock and unlock a cell in the excel depending ypon a value
that is been returned from another cell.like if Cell A13 returns value 1 the
CEll A14 should get lock so that no one else can change/update the cell A13 &
visa versa.

Please help