In Excel 2007, under a protected sheet, I want to allow users to Insert Copied Cells in which one of the cells in the row is locked and contains a formula. Naturally, when the user selects Insert Copied Cells, the cell containing the formula should follow.

Any idea how I can do this when the sheet is protected?

Thanks,
Yani