I am using Excel 2010 with a shared workbook. I need the formatting protected, but allow users to edit text and select from drop-down boxes.
Following the instructions in this answer to Protecting the formatting in Excel 2007, I have protected the worksheet and this works with one exception: If I double-click a text-field then its contents are erased. Prior to this, if I double-clicked the field it would allow me to edit the text there without first erasing it.
How do I protect the sheet AND let people edit text in a cell without erasing the entire content of that cell first?