Insert row in a table on protected worksheet

Anonymous

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.

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

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

0 comments

9 additional answers

Anonymous

2012-09-10T23:24:23+00:00

Hello Teylyn,

This is one way to insert rows, anyway my users are not really familiar with excel, and it gonna be quite hard to them.

Do you know a macro which can insert cell by clicking into the last cell in the row above the total row and then press the Tab key.

You know, Im not really familiar with macros, however it will be my next course!

Thanks a lot
Was this answer helpful?

0 comments No comments