I have an application where I am constantly moving a worksheet from one
workbook to some other workbook. I would like to automate the Edit ...Move
or Copy Sheet ... To Book sequence a little. Is there a way of calling the
Move or Copy Dialog Box directly from VBA?

Thanks,

Frank Hayes

Hi Frank,

Try:

Application.Dialogs(xlDialogWorkbookCopy).Show

---
Regards,
Norman



"Frank & Pam Hayes" wrote in message
news:0Wyid.857$oa1.192@trnddc03...
I have an application where I am constantly moving a worksheet from one
workbook to some other workbook. I would like to automate the Edit
...Move or Copy Sheet ... To Book sequence a little. Is there a way of
calling the Move or Copy Dialog Box directly from VBA?

Thanks,

Frank Hayes

That worked beautifully! Thanks.

Frank

"Norman Jones" wrote in message
...
Hi Frank,

Try:

Application.Dialogs(xlDialogWorkbookCopy).Show

---
Regards,
Norman



"Frank & Pam Hayes" wrote in message
news:0Wyid.857$oa1.192@trnddc03...
I have an application where I am constantly moving a worksheet from one
workbook to some other workbook. I would like to automate the Edit
...Move or Copy Sheet ... To Book sequence a little. Is there a way of
calling the Move or Copy Dialog Box directly from VBA?

Thanks,

Frank Hayes