You should get all open workbooks in the drop down. Pl. check again.

Also go to another workbook and see whether you get the complet list in the
dropdown..

As a workaround -
You can always select the whole sheet and copy into a blank sheet in another
workbook.

"3Nails" wrote:

I need to copy a worksheet to a different existing workbook. I have tried the
right click on tab, then Move / Copy, but the drop down list does not include
the workbook I am trying to copy to, only the one I'm copying from and "NEW".
I have both workbooks open and unprotected, as well as the worksheet
unprotected. Any ideas? Thanks....