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?
Best Answer
The properties of the cell are both 'Locked' and 'Hidden'. Once you uncheck 'hidden', the cell will function as you desire.
If you need more info on permitting users to edit ranges, here's the site I learned from. The answer above isn't there, but many people eventually come across this issue.
http://www.officetooltips.com/excel/tips/allow_specific_users_to_edit_ranges_in_a_protected_worksheet.html