When protecting a worksheet, add option to allow users of the worksheet to add a row entry.
When protecting a worksheet, add option to allow users of the worksheet to add a row entry. Currently there are options to allow users of protected worksheets to edit entries and delete them but not to add new ones to the last row. EG: I have a worksheet which works out due dates based on last seen dates. The staff I work with are great but will type over the formula if left unprotected, this means I need to protect the worksheet on those columns. When I do this, the staff can add a line but the formula will not calculate as the protected worksheet does not have the option to add a new entry so those cells are locked against formulas. Therefore I am stuck as I can protect the cells but staff can't get the auto update, or I can unprotect it and staff will likely delete/override the formula by accident. As a note: I use the fill down method for the formula as it will never run out no matter how long the sheet is used or how many rows are deleted. It is not feasible to type the formula into the sheet and fill as needed then re protect.
Jim Kemp commented
My issue is similar - I want users to be able to insert copied cells into a protected worksheet as either a new row or a new column, keeping the formulas protected.