Surely just clicking the X at the top left will produce
this.

However, if you want a button to do this then create the
button and in the code put ThisWorkBook.Close
If changes have been made then you will be prompted to
save them.

hth
-----Original Message-----
Could anyone write me a macro to close the spreadsheet
and prompt to
save changes? I need to link it to a button on my
spreadsheet.

thanks for any help


---
Message posted from http://www.ExcelForum.com/

.