Locking cells based on the value of other cell

Question

I am using google sheetsI 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.

sergeibaklan · Answer

ajl_ahmed&nbsp;
Afraid not, Goggle Sheets doesn't support VBA.&nbsp;

nikolinode · Answer

ajl_ahmed&nbsp;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.&nbsp;&nbsp;Hope I was able to help you with this link.NikolinoDEI know I don't know anything (Socrates)

ajl_ahmed · Answer

Thanks for your reply.Does this method work on Google Sheets? Can I activate and use the VBA code for Google Sheets?

Forum Discussion

Locking cells based on the value of other cell

Share

Resources