Insert row in a table on protected worksheet

Anonymous
2012-09-10T03:00:57+00:00

In the same way we can add rows into the table by clicking into the last cell in the row above the total row and then press the Tab key. It would be really useful if it could works in a protected sheet,workbook.

How can I do it? Macro? how can i write it?

My sheet is really simple, but i need to protect it from the final user!

My tabel contains:

Three columns

A(date), B(Summary), C (Inflows)

In the rows, the final user need to input the data.

Also in the end of the table has a row with total.

I need to leave unprotected only the table's rows, however the possibility to add row must be available to the final user, because this table could have more than hundreds rows.

Thanks  in advance for your reply.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2012-09-10T04:14:26+00:00

Hello,

if you format the table cells to be unlocked, then protect the sheet and tick the box next to "Insert rows" in the list of settings the user is allowed to do, then the end user can insert rows into the table.

The tabbing to automatically create a new row at the end does not work in a protected sheet, but the user can select the total row and use the Insert row command to add a row to the table.

cheers, teylyn

Was this answer helpful?

10+ people found this answer helpful.
0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2015-11-19T17:21:51+00:00

    This seems like an idiotic design:  of course users will select unlocked cells .... those are the ones that contain the data to be used and viewed:  

    Is there any workaround to this so that unlocked cells can be selected AND insert rows / columns will work?????

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-04-25T12:22:16+00:00

    Please start a new question, Sanjeev. And please consider that not everybody who answers questions is a man.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments
  4. Anonymous
    2013-08-20T15:50:18+00:00

    However, if you select "Select unlocked cells" along with "Insert rows", the ability to insert rows unfortunately goes away.   :-(

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments