I can use code to open a password-protected workbook, and copy data
from a worksheet.
However, when I try to paste the data into a unprotected workbook (and
unprotected worksheet),
Excel prompts for a password.

I am very sure this happens at the PASTE stage, because I traced the
issue line by line using the
STOP command to see where the application prompts for the password.

Question is, I have already opened thw workbook by supplyhing the pwd
in the VBA code.
Why does Excel prompts for password before I paste to a UNPROTECTED
worksheet?

How do I avoid this in vba code?

Thanks in advance for your kind help.

Larry