Creating a "save as" macro

What I'm attempting to do is create a macro to save a document so that the document will be saved under a name that corresponds to a cell. I have tried recording the macro, but it only allows me to save it to a specific directory with a spec name. On my worksheet I have a drop down menu to select the a specified number. When i hit the "save" button, I'm wanting it to save as a file name that is in the cell from the drop down menu. I've posted a pic to help explain. Sorry if terminology is incorrect.
excelhelp.jpg

You will laugh when you see how easy this is.

Put this code in the same worksheet module where your button is located. Change the name to correspond to the actual name of the button.

Please Login or Register  to view this content.