Hello:

When "Copy or Move" sheet, in the dialog there is an opportunity to
define a workbook to copy the sheet to. However if I created a macro, it
does not reflect my choice, i.e., it comes the same whether I define or
not define a workbook.

Furthermore, when I run the created macro

Sheets("sheet").copy

the first time, it places a copy of sheet "sheet" as "sheet (2)" in the
same book. However, when run the second time it creates a new workbook
without my meaning to.

My question: is there a way to specify in the macor the workbook a sheet
is to be copied to.

Thank you,
Alex