Inserting Rows and Protected Formulas to Appear on Inserted Row

Bit of a weird one here but here goes.

I got a spreadsheet I need to protect the formulas so these are not deleted or changed in anyway as there are multiple users using the template throughout my place of work.

So I've password protected the spreadsheet and locked and hidden columns U, W, X and AA so the formulas cannot be viewed or deleted but errors if attempted to.

However, I need to be able to insert / delete rows and columns so I've allowed users to do this but the formulas in columns U, W, X and AA needs to appear on any inserted rows.

From looking on line looks like I may need to use Macros or VBA or both, not being an expert on these can anyone help.

Any help will be greatly appreciated.

Thanks

Originally Posted by AliGW

Yes, you will need a bit of VBA. I'll move the thread to the appropriate section.

Many thanks AliGW