Expand table rows in protected sheet

**pezalmendra** · 04-13-2014, 05:08 AM

Hi,

I am stuck in something I am sure it is easy but cannot get with the solution...

I have a table that when the sheet is unprotected I can insert easily a row by pressing the "Tab" key when the last cell from the table is selected. But this I cannot do it when the sheet is protected!

Any ideas? I have attached an example.

Hope someone can help me on this.

Thanks,

**RudiS** · 04-13-2014, 07:54 AM

Hi,

AFAIK, this is an annoying part of tables (or List Objects). They don't handle sheet protection very well.
A way around this is to use macros, and a convenient worksheet command button can facilitate the inserting of rows.

See the attached sample file...