Formula/Function to lock and unlock a cell in excel

R

Ridhi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Word macro that can call cells out of Excel for a find and replace 0
FORMULA/FUNCTION TO LOCK AND UNLOCK A CELL 2
entering value in a cell 4
Excel does not accept text format! 0
Merging from an Excel file with graphics 1
unlocking cells 12
Allow VBA code to change a locked cell?? 3

Top