copy to protected sheet
Hi Bob,
Sheets("test").Select
ActiveSheet.Unprotect Password:="your password"
ActiveSheet.Paste
Abdul Salam
-----Original Message-----
i am trying to copy to a range of unprotected cells in a
protected sheet.
the following will give an error after paste if
destination sheet is
protected.
what copy statement would work
thanks
' copy from data to test
Range("A1:P350").Select
Selection.Copy
Sheets("test").Select
Range("W8").Select
ActiveSheet.Paste
' add autofilter back
Range("W12:AL12").Select
Application.CutCopyMode = False
Selection.AutoFilter
End Sub
.
|