Trying to create a new workbook but the Method 'Copy' of object'_Worksheet' failed error keeps preventing the copy process.
I've attached a workbook. The Macro is run from the NewMODSheet WorkSheet.
The Button says " Add A New WorkBook"
Caution! The attached worksheet crashes when the Macro runs.
But at the bottom of the sheet it shows copying.
A new Book1 is created, but it's hidden from view, and the worksheet crashes.
The same code works on other sheets.