No, the name of the workbook is its saved file name (the exception being
Book#). You can not change that default name except by saving the workbook.
(You could always kill it after you are through with it).

--
Regards,
Tom Ogilvy

Tommy T wrote in message
...
I am copying a worksheet into a new workbook. Is there a
way to name this new workbook something other
than "Book1" without saving it?

Thanks,
-TT