I hope that this is not to dopey but my knowledge of Excel VBA is quite limited.
I have a macro that in essence produces a cut down version of the master file from where it is run that I distribute elsewhere but I need some code at the end that forces me to save the file with a different name.
Yes I know I should keep my wits about me but I have a fear that one day I might overwrite the master file.
So in essence I would like some code that for this macro only forces SaveAs and does not allow me to overwrite the original.
Your help would be most appreciated