Nov 23 2022 01:00 PM
I am using google sheets
I have a column and the cell's value is determined using drop down list. How can lock the cells of this column based on the other cell value?
Thx.
Nov 24 2022 11:06 PM
How to lock or unlock cells based on values in another cell in Excel?
In some cases, you may need to lock or unlock cells based on values in another cell.
For example, you need the range B1:B4 to be unlocked if cell A1 contains value “Accepting”; and to be locked if cell A1 contains value “Refusing”.
How can you do to achieve it?
The upper link maybe can help you.
Hope I was able to help you with this link
.
I know I don't know anything (Socrates)
Nov 26 2022 08:13 PM
Nov 27 2022 08:11 AM
Afraid not, Goggle Sheets doesn't support VBA.