lock a total row below a list & allow inserting in the list?
When I place a total row below, but outside of, a list and another
calculated row below that then lock and protect only the total and calculated
rows, the insert function in the list goes away. I want to allow users to
add new records to the list but not change the formulas in the two rows below
the list. Is this possible?
|