Calling the "Move or Copy" Dialog Box from VBA
 

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

Calling the "Move or Copy" Dialog Box from VBA
 

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

Calling the "Move or Copy" Dialog Box from VBA
 

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