Protect sheet but keep table expandable

Hi,

REQUIREMENT:
I have a sheet where I have a table with several columns. I need to make sure my user never changes a particular column which contains a formula. I would like my user to still be able to Add rows to my table via the TAB key and modify all other cells in the table which are not in the mentioned column.

QUESTION:
Is this possible?

What I have tried:
1. Select all worksheet cells > Format Cells > Protection > un-check Locked
2. Select the Table column I want to protect > Format Cells > Protection check Locked
3. Protect worksheet > "Allow all users of this worksheet to" check everything


No matter what I try - once I have locked the sheet , my table losses it's little "pull down" triangle in the bottom right hand corner. Also, if I push tab no new rows are created.

Thanks very much in advance,
Michelle

Thanks Teylyn - I was suspecting such an answer... I was just hoping (hoping!) that Excel 2013 had perhaps found a more eloqent solution. Thanks none the less... I think i spent about 2.5 hours trying to figure out the un-figrable

I know this is a day late and a dollar short but this was my solution to a similar issue.

Unprotect any column you want the user to be able to type in within the table and lock everything else.

In the worksheet change event do as follows:

Please Login or Register  to view this content.

By the time you unlock the sheet it is too late to trigger the table to add a row on its own. But the value the user entered is there so reassigning it triggers the table to add the row. Then you just re-lock and its good to go.

Thank you Box Jockey

hi, Box Jockey..

i've try your solution, but nothing happen on mine :\

please help

Originally Posted by Box Jockey

I know this is a day late and a dollar short but this was my solution to a similar issue.

Unprotect any column you want the user to be able to type in within the table and lock everything else.

In the worksheet change event do as follows:

Please Login or Register  to view this content.

By the time you unlock the sheet it is too late to trigger the table to add a row on its own. But the value the user entered is there so reassigning it triggers the table to add the row. Then you just re-lock and its good to go.