VBA Code/Macro to insert rows into a protected sheet and copy formulas down

Hi,

I am very new to VBA and Macros and to be honest new to all the extended functionality in Excel. What I am trying to achieve

I have created a table in excel and the first column is based on a drop down list in a separate sheet. There are approximately 8 items in the list and each one has adjacent cells that has data I want to copy through to the main table and auto fill certain fields.

I have successfully managed to do the first step using Vlookup.

I also want to protect my worksheet to stop people changing the formulas and values in the auto filled cells on the main table and allow people to add additional rows, select from the drop down in column A and auto fill the cells when the work book is protected. This is the part I am now stuck with.

Does any one have any examples how to achieve this using VBA/Macro.

Ideally what I would like is the following:

- Add a button on the sheet that allows me to insert a new row in the protected sheet ideally where the cursor is on the sheet
- Ensure the formula and drop down list is copied into the new row from the above rows
- Select an item from the drop down list and depending on the contents auto fill the adjacent cells.

I have attached what I have done so far if this helps.

Hope someone can help. I am also new to the VBA editor as well so some explanation might be required as well