How to allow user paste(Ctrl + V) a row to protected sheet(some columns are locked)

[openSuSe]

Hi, guys
I want to allow user copy(Ctrl + C) and paste(Ctrl + V) a row.
because some columns are locked and the sheet is protected.
so, when user doing so, a warning dialog is show and can't do the paste.

so, I want to make it available in code.
what I want to do is add some codes in this function:

Please Login or Register  to view this content.

and in Worksheet_Change function, I protect the sheet again.

But I find that when I do Sheet1.Unprotect , the clipboard is empty!!!
I just want to allow user can copy and paste a row, the locked cell's value can be ignored.
But I can't find a good solution.
Any help?

Thanks in advance.

[se1429]

Hi

In your case you test CutCopyMode for xlCopy as follows:

Please Login or Register  to view this content.

Please retry.

[royUK]

openSuSe, please reade the Forum Rules & stick to the original post until solved!