Liz has attended:
SharePoint course
Preventing row insertion
Hello
Is it possible to protect a worksheet or workbook against insertion of new rows?
We have a workbook in which one worksheet is a distribution list and the others are document issue records.
We link the distribution list to the other sheets (using paste link) so that when new people get added to the distribution list during the currency of a project, each issue sheet is updated.
This system is ok so long as new people are added to the end of the distribution list (because we copy a range of blank rows and link this throughout the workbook). However, the system fails dismally because we can't prevent users inserting people in the list. Please suggest a solution. thank you.
RE: 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
