Preventing row insertion

Liz

I strongly advise you to test this on a copy of the worksheet or workbook you mention. You will need to experiment with this solution to see if it does what you want.

You will need to first decide what cells you will alllow people to paste information to.

Highlight those cells in question and go to Format - Protection and uncheck the lock for those cells.

Note that all cells are locked by default BUT the lock DOES NOT COME INTO EFFECT UNTIL YOU PROTECT the sheet by going to the Review Tab and select Protect Sheet.

With the Protect sheet Dialog box displayed
Make sure the first box is ticked Protect Worksheet and contents of locked cells

You can enter a password for sheet protection but leave it blank while your testing

In the section allow users of this worksheet to ensure
select locked cells and select unlock cells is checked
Checking other boxes in the list will grant users rights to perform the specifed action.

Hope that helps

If you want further assistance please note that we offer advanced consultancy services

Many thanks