Inserting New Rows in Protected Table

That's rather the point of protecting the worksheet and accepting the default protection.

Try ticking the box to allow the insertion of rows when you protect the sheet.

Time to upload your actual workbook methinks and explain exactly what steps/actions you take and what you want to happen.

Hi,

See the FAQ - Reading & Posting messages.

Ahh! I see that by table you were referring to the TABLE functionality wherein it automatically expands and adds new formulae when you start typing a new row.

You've hit one of the downsides to the Table functionality - there are others in my opinion, and that's that you cant have Tables update when the sheet is protected.
The essential question is do you really need the TABLE functionality? Ironically we had a discussion on the subject of Tables recently and many of us find them tiresome.

I rarely use them and for stuff like this where you want to control additions to a database the approach I always adopt is to have a dedicated data entry row above the data (which is a normal range not a TABLE) for original data entry. Unlock any cells for which you wish to permit entry and Protect the worksheet. Then have a button which runs a small macro that temporarily unprotects the worksheet, (inserts a new first row to the data if you want the new record to be at the top), copies the new record data entry row and pastes it to the new first row, or at the foot of the table if you prefer. the macro then concludes by putting sheet protection back on.

Mmm!

There's no reason why the macro wouldn't work and it could be sheet independent and work with any tab.

However you've mentioned the dreaded words 'shared workbook'. Most of us avoid these like the plague since sharing causes too many problems in areas that needn't concern us just at the moment. You certainly couldn't have the macro running at the same instant if it was selected by two people at exactly the same moment, although in practice since it's a simple macro and runs in milliseconds, of itself that needn't be a problem.

I'm implying from your description that you have separate tabs dedicated to individuals for them alone to add to. If so and if the essential of the task is to gather summary data for many individuals then personally I'd change my approach and let each person have their own individual workbook. Then for summary information I'd have someone with a master workbook whose sole task is to run a macro which gathers all the relevant data from the individual workbooks into a single database in the master workbook.

Originally Posted by RSa

I've already got a macro worked up to combine all these tabs into a new "Master" sheet, just not sure if they want each individual to have their own workbook. I think they are trying to keep all this information together in one workbook.

It was worth a shot - I appreciate all your help.

Your on the right lines with a Master workbook that gathers data from multiple workbooks. Now you just need to convince 'them' that they are on a potential route to disaster with a shared workbook that has any sort of functionality that departs from very basic stuff.

FYI, you can't share a workbook with a Table in it anyway, nor can you change protection once it's shared.