I have a questionnaire matrix to be filled in by others. I would like
to protect the form from changes in format. However, others should be
able to fill in the form by choosing from drop down list and/or writing
in cells.
The way I have been trying is: tools, protection, protect sheet, insert
password, ok. Tried variations with contents, objects, scenarios boxes
all ticked/partically ticked/blank. However, in all cases, the sheet
becomes read only and does not allow to be filled in.
Thank you for your help.