Insert Copied Rows in protected Sheet. Help

[HiSoC8Y]

Hi everyone.

I have a worksheet that is protected, and i have given the user to insert rows. The user can insert rows, that works. However, if i copy a complete row and try to insert it, it doesnt allow me. I need to do so, because i have formulas in that row which i want it to be copied also.


So what can the solution be?

Thanks, and this is a great place for excel knowledge.

 

[ChiragAmin]

Erik,
I am new to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> coding so I just simply copy and paste above code and it works. But it works only when you run the macro.
Is it possible that the same code auto-runs when you click on Paste.
Please advise. Thank you.

this is the basic macro to start

Sub test()
ActiveSheet.Unprotect "password"
With ActiveCell
.EntireRow.Copy
.Insert Shift:=xlDown
End With
Application.CutCopyMode = False
ActiveSheet.Protect "password"
End Sub

you will probably have some requirements ...

first do some tests please