Good evening all,
Sorry for the lengthy subject but not easy to explain.
I have a table in an excel worksheet. I want to lock a number of columns in the table (but not all) and then protect the worksheet to ensure that formulas in those columns are not accidentally deleted/changed. Unfortunately, once I protect the worksheet I am no longer able to add rows to the table via entering a new invoice number in the first column.
In the attached example a new invoice number in column A will, when unprotected/unlocked, will automatically add a new line across the table column range. The locked columns are H and J.
Any help would be appreciated - there is no password.