I've seen a number of community entries referencing a desire to be able to lock an individual cell. I too would vote a resounding yes to a feature of this type. I've got a number of task list sheet where this is needed. My sheets have 10 major task and each major task has a number of subtask under them. My columns are various date entries such as:
Start, Actual Finish Date, and Contract Due Date
I only want these date field entered for the Major Task line, not each of it's sub task. I can't lock the subtask row because there are a couple of columns that do need to be filled out for the subtask (Assigned to, Item Completed). I would like to cell lock each of the date cells for each of the subtask.
Right now I'm having to fill these cells with black background color to not show any mistaken entry.
I'm trying to make tasklist sheets as simple as possible for a group of PMs. Once I get them used to using collaboration tools I can add more options.
