Solution 1:
Before you protect the sheet, right click on the cell you wish to be able to have someone submit a response in. Select "Format Cells..." on the "Protection Tab" uncheck the "Locked" option. do this again for any additional cells you wish to be editable. Then add your protection back to the sheet and see if it works. If not, try solution 2.
Solution 2:
Before you protect the sheet, go to the "Review" tab and select "Allow Users to Edit Ranges" under the "Changes" Section. Select "New". give the New range a Title. and then in the "Refers to cells:" box, Hold Ctrl and click all cells you want to be editable before releasing Ctrl. Leave the "Range Password:" box empty and select the "Permissions" box at the bottom of the window. Select "Add" and type "User" in the object names box. then again select "Add" and type "Administrator" in the object names box. After all "Groups" or "User's" have been added to this list make sure you check mark the box below that says "Allow" next to "Edit range without a password"
***NOTE***: if you are part of a company with a company login you may be given several options to select after typing in "User" or "Administrator", you will have to "Add" them all to this list if you don't want to have to do this again in the future if someone finds they do not have access later on.
Hopes this helps!
@sootsie74
