Macro to insert row in protected sheet

[stirish]

I have a question. I created a macro button to insert rows in a workbook that has 5 week sheets. The button is only working on the first sheet and I get the VBA error 400 on the other 4 sheets. Also when i protect the sheets the macro stops working. Hoping for some help.

Thank you as always!

 

[wrightyrx7]

Can you paste your code?

 

[DanteAmor]

Try this:

Sub Macro14()
'
    Sheets("Sheet2").Unprotect "abc" 'change abc for your password
    '
    'here your code
    'for example:
    Sheets("Sheet2").Rows("5:5").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    '
    '
    Sheets("Sheet2").Protect "abc"  'change abc for your password
End Sub