ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Locking/Unlocking based on another cell value (https://www.excelbanter.com/excel-worksheet-functions/181551-locking-unlocking-based-another-cell-value.html)

Iriemon

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


All times are GMT +1. The time now is 06:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com