VB button & code to save workbook

I am trying to make a invoice for work , I have a couple of bits i will try and explain that require a vb code. I don't know to much about VB and would not know where to start. Could someone please help me with this.


I have inserted the workbook. I am wanting to make an invoice. In D5 i have a drop downlist with a list of names and a save button. I would like to find a code that when i click the save button it would automatically save the entire workbook to a directory on my server "\\server\invoices\" The name of the saved file would be the name that's in cell D5 from the drop down list.

When the save button is clicked i would like it not only to save the workbook but to close it but not save the original file, so the next person that opens it gets a clean invoice.

One last thing on the saved workbook i would like the macros to be disabled so no-one can change any info or click save again etc.