I'm a mechanical designer in mechanical field, in a project we have varies
type of support with differents height, I use excel to calculate all the
details value and intend to share this worksheet with other. I will only wish
to allow user to fill in the support height, the rest will be generate by
excel. If I have lots of support , that's mean the user have to copy and
paste in a new row, If I protected the work sheet, user are not allow to
paste in a new row. That's why I need to paste some locked cells in an
protected sheet.

"Dave Peterson" wrote:

Wouldn't that defeat the purpose of locking the cells on a protected sheet--to
stop changes to those cells?

angeline wrote:

Please allow paste locked cells and unlocked cells in protected sheet

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions

--

Dave Peterson