Protecting cells with formula, but retaining the ability to use the "data, group" function
Posted by Patrick Desbois on August 22, 2001 4:39 PM
I know how to partially solve a problem, regarding cell protection. It's easy to protect a whole sheet or specific cells, BUT if you have a series of columns / rows that are group, you'll lose the ability to view them grouped or ungrouped, since you're protecting cells within.
I know a way that uses "Data Validation", which is ALMOST perfect. This forbids anyone from inserting, by accident, a value where there's a formula (and you retain the ability to view grouped rows / columns). BUT it is possible to use the kys "DELETE" and "BACKSPACE" to destroy cell contents and formulae.
Does anyone know how to completely protect formual cells from changes and delete / backspace, while keeping the ability to view group rows columns?