witek,
If it has been saved, you cannot *UnSave* it.
What you are asking makes no sense.

NickHK

"witek" wrote in message
...
But it is not that case.
Once again.
There is a workbook which has a name assigned to it. So File/Save will
not ask for name.
I need to remove filename, so next time when user will try to save it by
choosing File/Save Excel should display SaveAs dialog box.

Making copies, forcing Save as doesn't solves the problem.



Chip Pearson wrote:
SaveCopyAs does not require that the workbook be saved.


"witek" wrote in message
...

SaveCopyAs creates a copy and doesn't save current workbook.
Problem is that current workbook must be saved, not simply its
copy created. Why? Because of bug in Excel.




NickHK wrote:

witek,
.SaveCopyAs ?

NickHK

"witek" wrote in message
...


opened workbook, doesn't mean that I can write any code to it.

1.
Workbook is created from VBA code from scratch, but VBA code
is in

add-in.


For some reasons this newly created workbook must be saved.
After that if user saves it, it is saved under the temporary
name chosen
by me.
I don't want to and I can't force Save As option.
I would like to have it as a noname even if I saved it before.

2. if user saved using his own name, he needs option to leave
it open as
a noname, so next time choosing File/Save Excel will ask for
a name.

What I need is option like ActiveWorkbook.FullName = ""

Is it clear now?




Tom Ogilvy wrote:


I have an opened workbook which was saved by a user.

was your original problem statement. You have now
contradicted that.

If you determine what your actual situation is, then
certainly, post

back.


If a workbook has been saved, then it will have a name.
Possibly you

are


looking for a template.