Copy sheet dialog box appear RRS feed

  • Question

  • Hi:

      In Excel you can right click on the tab of a sheet in a workbook and a dialog box appears with options to copy or move the selected sheet and a drop down with a list of the open workbooks to select.

      What is the code to make the dialog box appear?  I don't want to recreate what is already in Excel.  I need to select the destination file and choose where I want the sheet to be copied to.

      Thanks, Don

    Friday, March 13, 2015 2:09 AM


All replies