Sorry for spamming.


Alright so....


1) if I use filling in forms restriction then I need to add content control in every cell of the table like in the image I attached because if I lock the "filling in forms" then I will be unable to make changes to the cells. I tried editing the code using your code as the bases but everything got even worse. I saw that your code had content control (1) so my guess was that if I add 3 more text boxes then I should have CC 2,3 and 4?


2) In my response above, I was unable to solve the run-time error "13", type mismatch. I tried changing the commands but that also ended up crashing the code completely.


3) I found a way to use your original code and when I do lock the form I just select restrictions for "comments" and I select the areas that I want to edit. It is not ideal mainly because when I add the row it takes the previous filled in text and pastes it into new row and I want column 1,2,3 to be blank and only copy the drop options in column 4. It is not idea but it is better than not having anything at all for now.