Activate new workbook with unknown name
Hi,
I have a macro that copies a worksheet from an existing workbook and moves
it to a new workbook (book 1, book 2, etc). I then go back to the original
workbook to hide the copied sheet. When all this is done I want the user to
be looking at the new workbook (book 1, book 2, etc).
Please provide some code to add to my copy macro.
Thank you very much....you guys/gals are great!
|