Adding new row keeping existing format all the wile keeping worksheet protected.

So I am creating an equipment log which has some locked cells I want to be able to add a new row keeping the formatting of the rows. I have most if it down but it selects the row which a cell is selected.

then it inserts a row just below it. How can I modify this VBA Macro to add a blank row to the bottom keeping the existing formula? the blue plus signs have my existing macro attached.

the password is equiplog

Thank you

Have you considered using an Excel "table" - which formats and copies formulas automatically
- try in attached sheet (which includes a very simple example) by adding some values in row 5
- column A retains BOLD format
- column F retains formula and format
- column G retains drop-down and conditional format

You could capture the data in an Excel table and link it to a "pretty" worksheet for "those who must be obeyed" (perhaps on a "trial" basis and then never get rid of it!!)
Sounds to me like there are still a few dinosaurs roaming around locally

I'm guessing that you will not be taking up my suggestion , so I'll sort the macro for you when I have a minute or two later today.
It would be sensible to keep it simple - so do you want to add 1,5 or 10 lines each time (or even a different number) - it does not cost anything to have a few formatted lines, so you can afford to go high!! And if stegosaurus does not like untidy formatted empty rows, we could have another simple macro to delete those in one hit as and when required.

a couple of questions:

Your workbook contains 1 sheet, but the code is written to apply to all sheets in the workbook
- are there multiple sheets and do the same number of rows get inserted into each sheet?

Am I missing something here?
- We want to add rows at the bottom of the data - so why are we inserting rows?
- Is there any reason why we cannot just copy the formatting and data validation from the last 2 used rows and paste those to the next 2 rows?
(- there do not seem to be any formulas to concern us in the worksheet - could be catered for though)

Excellent
Thanks for the reps