Protection from format changes allowing form to be filled in

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.

Unprotect the worksheet (if you have it protected).

Select the cells that the users can change
format|Cells|protection tab|uncheck the Locked box.

Now, reprotect the worksheet
tools|protection|protect sheet

With the worksheet protected and the cells unlocked, the user should be able to
change the values in those cells.

If those dropdown lists are dropdowns from the Forms toolbar or comboboxes from
the control toolbox toolbar, then if you have linked cells, make sure those
linked cells are unlocked, too.

Clare wrote:
>
> 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.

--

Dave Peterson