View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank & Pam Hayes[_2_] Frank & Pam Hayes[_2_] is offline
external usenet poster
 
Posts: 34
Default 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