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.