I still do not get it. If I unprotect the sheet, no password assigned. I still can not copy and paste. Only paste manually using the Excel clipboard.

My thinking still is that there is not a relation with passwords. That is why I not see the purpose of the code provided.

More where there is a comment from Microsoft as mention above and below

" Using the Worksheet_SelectionChange event will clear the clipboard, which disables the Paste Special option. To enable the option, you need to set the value of the Application.EnableEvents property to False."

Something is disable the paste option, in my opinion.

Thanks.