ExcelBanter - Formula/Function to lock and unlock a cell in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formula/Function to lock and unlock a cell in excel (https://www.excelbanter.com/excel-programming/409696-formula-function-lock-unlock-cell-excel.html)

Ridhi

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

All times are GMT +1. The time now is 06:56 AM.