I need a macro to insert a new row in an Excel 2010 table in protected worksheet and make that row (only) unprotected. This will protected the other data in that table while users enter additional data. The sheet protection must use a password too.

Thanks for any help received!