I am trying to develop the table mainly because it will automatically add the formula when I have entered the value in one cell.
But the problem is I am not able to edit when the sheet is protected.
Need solution for following things,
1. I want to lock the column formula because the user shouldn't change it.
2. If I lock the column I am not able to add rows and columns which affects the actual purpose of the Table format.
Kindly give a solution for the above issue It would be very helpful.