Need a "save & close" button directly on spreadsheet
 

I need a button which, when clicked, will do a "Save" and close the
file, exactly as if you'd clicked "Save" in the File menu. The thing
is, this needs to be a button directly on the spreadsheet, next to some
other buttons I have on there that run macros, NOT a button on a
toolbar. Is there a macro that will do this that I can connect to a
button?

Thanks,
Ron M.

Need a "save & close" button directly on spreadsheet
 

Here you go:
Sub SaveAndClose()
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
************
Anne Troy
www.OfficeArticles.com

"Ron M." wrote in message
oups.com...
I need a button which, when clicked, will do a "Save" and close the
file, exactly as if you'd clicked "Save" in the File menu. The thing
is, this needs to be a button directly on the spreadsheet, next to some
other buttons I have on there that run macros, NOT a button on a
toolbar. Is there a macro that will do this that I can connect to a
button?

Thanks,
Ron M.