insert rows with the formula in a protected sheet

[meghachaudhary]

Hi,

I have a spreadsheet that runs from A23 through Q31. I have formulas in column H, I, O and P. I protected the sheet but it wont let me insert/delete rows. And if i run a macro for inserting rows, the columns H, I, O and P doesnt have the formula and it wont even let me drag it because the sheet is protected. I am pretty new to VB and it would be great if someone can help me with this. I want to able to protect the sheet so that the user cant edit the formulas but at the same time they should be able to insert and delete rows.

Thank you so much in advance.

[Motu040602]

You could unlock you sheet in the macro and relock it at the end with these commands
ActiveSheet.Unprotect
ActiveSheet.Protect
When you insert the new row/rows copy the cells with the formulas, then paste them into your new row/rows. All this can be done with VBA. I am not of you comfort level with writing the scripts. Good luck!

[meghachaudhary]

Thank you for your answer. But I do not want the user to know the password and unprotect the sheet at any moment. Can this be achieved by VBA? Again, I want to run a macro in my spreadsheet which lets users insert a row with the formula in the column. To simplify, L22 has formula = =E22*H22*K22 ; L23 has formula = =E23*H23*K23 and so on.

[Motu040602]

This link will show you how to password protect you VBA code

http://www.ozgrid.com/VBA/protect-vba-code.htm

This way no one will be able to see you password.