Excel 2007 : Comment Locking & Allow Cell Editiing

[otter]

I have a group using an Excel 2007 worksheet as a communication tool. I'm wondering how I can allow staff to edit and copy data from various cells and yet, prevent them from deleting the instruction comments attached to the cell?

[patman0919]

Otter,

If I understand you correctly you only want to lock a few cells not the whole sheet. The way i would do this is select the worksheet, right-click, format cells, select the protection tab, uncheck the locked checkbox, click OK. then select the cells that have the instructions repeat the process, but check the locked checkbox. Protect your worksheet and now they will only be able to edit the cell you wish them to edit.