View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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