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
|