Locking Columns/Drop Down Lists

Ann H

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?

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.