If you save as a template then the user would be asked to rename it or it
would be given a name + 1,2, (next sequence number)

--
Wendell A. Clark, BS
-------------------------------------

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. If you are not the intended recipient,
please notify us by reply e-mail. You are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited.
If you have received this communication in error, please destroy all copies
of this communication and any attachments. Contact the sender if it
continues.


"witek" wrote in message
...

I have an opened workbook which was saved by a user.
Now I need to treat this workbook as a new, so after clicking File/Save
(not Save as) Excel will open dialog window to provide filename.

Is there any way to do this from VBA?