Inserting rows with formulas in protected excel sheet

Copper Contributor

Hi,

 

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. 

 

Regards

1 Reply

@HV2021 

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.

 

Nikolino

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.