Locking Columns/Drop Down Lists

Ann H
Ann H ✭
in Formulas and Functions

I need to be able to protect formulas in a column for the parent rows but still want people to be able be able to select child drop down cells. If I lock the column will this stop people from being able to use the drop down lists? If so what other options do I have to protect the parent rows' formulas?

Tags:

Answers

  • Frank Falco
    Frank Falco ✭✭✭✭✭✭

    If you Lock the parent rows, that should protect the formulas and allow you to edit the children popups.

    This will stop Editors but not Admins from editing the parent formulas.


    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Categories