After reading the template it seemed by adding a "row" you meant a whole new table for a second or third "Suspect" The attached template has buttons:

1. "New Suspect"
2. "Delete last Table"
3. "Print"

Pressing the "new suspect" button unprotects the document, copies the data table and pastes it below the first one then re-protects the document. If you press it again it will keep adding a new table under the table so it's probably best to add all the new tables you need before you start filling them in as it copies everything including the text box contents.

The "Delete last table" button doesn't actually delete the last table, it deletes whatever table the cursor is in. Pressing the button unprotects the document, deletes the data table that has the cursor in it and then re-protects the document.

The "Print" button hides the buttons before printing and the reshows them.

You'll need to give the document your own password and enter it into the code in two places where it says "sPassword = """ add it between the quote marks.

Hope this helps.

Regards

You'll need to add your password to the code

Attached Files

New Suspect Sheet R0.dotm (55.3 KB, 7 views)