Programing a Save Function in Excel using VBA

[Hornet2433]

Help!! I am at the final steps of a new program I am writing in excel using VBA, but I am stuck. I need to have a function that when the user clicks the save button (on the worksheet) a "save as" file is created.
I do not want the user to be able to alter the original program as they will have to use it to create other proposals in the future, but I do want them to be able to open a previously saved proposal. Any suggestions? Would a scenario be best? SaveCopyAs? I am going crazy! Thanks

 

[castor2003]

Do you have a Unique name to save this file as?
You will have to hard code the name of the original file so that when the copy opens and then saved, does create an unwanted second copy.

OR, you can skip all the crap I have said and Password protect your VBA project then save the worksheet as Template. File->Save As. Place that template in your users shared templates. Each time they open that template, they will be creating copy. If the template name is Love.xlt, each time the use opens it 'love1.xls', 'love2.xls' will be created and so on.

Hope I helped...

 

[Hornet2433]

That is a great start, but one more question...

is there a way i can make am input box that the user can name this file?

 

[DrBowes]

Use:

Application.Dialogs(xlDialogSaveAs).Show

 

[Hornet2433]

That did it Thanks!