How to copy a row with formula in locked cells & insert copied cells in a protected sheet

**one23** · 03-29-2014, 04:22 AM

Dear Friends,

Have you ever copy a row with formula in locked cells & insert it in a protected worksheet? could you tell me how to do it? Many thanks.

**p24leclerc** · 03-29-2014, 09:56 AM

try the following macro:

Sub Copy_Protected_Cells()
'
'You first need to unprotect the destination sheet
Sheets("Sheet2").Unprotect Password:="pl"
'Then you can copy your cells from the protected one
'It is not necessary to unprotect this one though
Sheets("Sheet1").Range("A2:E2").Copy
Sheets("Sheet2").Range("A2").PasteSpecial
Application.CutCopyMode = False
'then you protect the destination sheet again
Sheets("sheet2").Protect Password:="pl"
'
End Sub