Hi, I have a table in a spreadsheet so users just begin typing in the next blank row to carry down the formulas and validation data from the row above.
However, when I protect the worksheet, the table new row functionality stops working. I have tried ticking / un-ticking all the protection options when activating the sheet protection but nothing seems to allow the table to create new rows. Can anyone provide a solution? I am trying to avoid macros where possible
Thanks in advance
However, when I protect the worksheet, the table new row functionality stops working. I have tried ticking / un-ticking all the protection options when activating the sheet protection but nothing seems to allow the table to create new rows. Can anyone provide a solution? I am trying to avoid macros where possible
Thanks in advance