@Mathukuma or any other code, saidia sirikali, I know you are a coder who messes up IEBC formualae, can you also mess up excel formualae.

I have developed workbook with multiple tabs. In each of the tabs, there are columns with specific formulae which are locked but allows for data input in rows(unlocked).My problem is that, I want users to input in data and add rows without giving them the rights/password to edit the formualae, I have tried using the excel developer tab and coding using VB unsuccessfully, can you do some CSR and develop a simple VB code to copy the formulae in the inserted rows without unlocking the columns as well as password protect the VB input module?

Simple example

row 1=cell A1(input data), Cell B1(Input data),Cell C1(Locked formulae),CellD1(Locked formulae) Cell E1(input data), Cell F1(Locked formulae),Cell G1(Locked Formulae).

I want users to insert in row 2 with the formulae in protected columns C,D,F and G being copied in row 2 as well

Saiti tafasari