Copy Worksheet

reklamo · Jun 17, 2009

I want to copy one worksheet to another open workbook with VBA.
I want the user to select any of the open workbooks to copy the worksheet to.
How can I call the dialog "Move or Copy Sheet..." from VBA?

Thanks for your help
reklamo

Gary''s Student · Jun 17, 2009

Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

reklamo · Jun 17, 2009

Thanks, it's working

Regards
reklamo

Gary''s Student said:
Sub msheet()
Application.Dialogs(xlDialogWorkbookCopy).Show
End Sub

Gary''s Student · Jun 17, 2009

Thanks for the feedback.