Unprotecting a workbook does not unprotect the sheets in the workbook.
Each sheet must be individually unprotected.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Lottery Numbers.xls... Excel picks numbers for 14 state/national (USA) lotteries - free)





"Larry"
wrote in message
...
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