I have a code in worksheet event like that
Code: Select all
Private Sub Worksheet_Activate()
With ActiveSheet
.Unprotect SPASS
.Range("C2:C4").Locked = False
.Range("A8:A" & Rows.Count).Locked = False
.Range("H8:H" & Rows.Count).Locked = False
.Protect SPASS
End With
End Sub
When I comment out the previous code, everything is OK. How can I enable the paste and keep the copied contents into the clipboard after the previous code.