How can I protect multiple columns and still be able to add rows in an Excel table?

Luladrao 

With the permission of everyone to add an example here.
In the uploaded file, a double click in column A (from line 2) opens an input box in which you can enter how many lines can be inserted.

The lines are then inserted under the line that was double-clicked.

The password for the sheet protection is Onofrio (if necessary change in the code).
I don't think it's good to automatically insert rows when changes are made in a specific cell.

Otherwise you have the problem that a new line is inserted with every change in the corresponding cell. For example, when you enter a value in the cell.

If you have made a mistake and change the value, a new line will be inserted again.

*I had the idea a long time ago somewhere on the Internet, I just don't know where, and I can't remember the source.

Anyway is just an additional example.
If it doesn't fit your project, please just ignore it.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.