You don't have to return to the original workbook to hide the sheet. If the
macro is in the original workbook then simply:

Sheets(1).Copy
ThisWorkbook.Sheets(1).Visible = False

Hope this helps
Rowan

"rt10516" wrote:

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!