Protect formulas but allow adding and hiding rows

new to VBA and not sure how to make this work.
I have a spreadsheet and want to protect it bc it has formulas in some columns that I don't want to get accidentally deleted. But I need to be able to add or hide rows, while copying the formulas from rows above.
I tried to create a macro for this but it just adds a row at whatever row I click on when making the macro.

any help would be super appreciated.

Thanks,
New to this

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "dumb newb question/help" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer