Need macro so file only saved with new name

[ILoveStMartin]

No sample attached as the file contains no macros.
File name is "Master if only one invoice",
If any data entered, don't want user to be able to save it without changing the name.
Believe it would require some kind of code so I could save file if changes require.
Thank you!!

[dangelor]

Possibly with...

Please Login or Register  to view this content.

...placed in the worksheet's code module.

[ILoveStMartin]

Super!!!!
You came at it from a different angle than I had in my mind but it will work just as well.
Question, if I see that some basic change to the file is needed, how would I get in to do that?
Thanks!!

[dangelor]

Easiest would be to edit the name in the code to something else and change it back when you're done. Second easiest would be to save the file as a different name, and change it back when you're done.

[ILoveStMartin]

Put it to the test - Selected Save - Got this (with name I changed the file to)
"Single Invoice -Must be saved in job folder.xlsm already exists. Do you want to replace it.", so it could be saved and the original lost.
Is there a way around that potential problem??
Also - when doing the save I realized I do not want it saved unless all needed cells have been filled in. I can set it so F14 will contain an "OK" when key cells have been filled in.
Do I need to go back and restate my need or enter a new post?
Thanks - Appreciate your help!!

[mikerickson]

Have you considered saving the Master book as a template? That file will be Master.xltx
When the user opens it and uses it, they will have to save it as a workbook. Even if it has the same name, it will have a different extension (.xlsx)

[dangelor]

To attempt what you ask will require a workbook. See the yellow banner above: HOW TO ATTACH YOUR SAMPLE WORKBOOK

[ILoveStMartin]

Thanks - buy why the Cross post link?? (Did not see it the first time I read your reply)
I am guessing that what triggered it was my "Oh - just saw something I should have included int my original post."
But I do not see the connection!