Inserting rows with formulas in protected excel sheet

New Contributor



I am trying to insert a row in the protected sheet, however it does not copy the formula given in the row above or below. Can you please help. 



1 Reply


As far as I know, it doesn't work without VBA.

Here is an example with VBA.

Password is "Nikolino" without goose feet.


I would be happy to know if I could help.



I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.