You're right; I missed that he was looking at the workbook instead of the
worksheet.

Robin S.
----------------------------
"Charles Williams" wrote in message
...
John,

Your analysis is correct: there is no way of changing the name of a
workbook except by Saveas etc.

IMHO leaving the name of the book as Book1 is the best approach because
the user is more likely to recognise this as the name of a new unsaved
workbook. Thats what I usually do, and then I give any sheets I generate
within the workbook meaningful names.

regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com