button to save and close the workbook

Wonder if there is a way (code) to program a Macro button on an excel spreadsheet that once clicked would save and close the workbook.

would be good also if I could maybe have two different buttons, one to save , one to close.

Im very much a newbie chump and have no idea how to write code, just copy and past is the name of my game.

Thanks in advance!

Darrell,

Please read the forum rules. There you will find that it is important that your Title is correct. VB Code Help ??

Change to something like "Button to Save/Close WorkBook"

... and then it would be a good start to record these actions
1) Save
2) Close

For the first you'll find

ActiveWorkbook.Save

For the second

ActiveWorkbook.Close

Now the question for you is how to put this under two buttons.

1) Drag two Command_Button (ActiveX Controls, from the developers toolbar) into your sheet.
2) Right click each and change the Caption into "Save" "Close" resp.
3) Double click the "Save" button. (the VBA editor opend and copy past the code

Private Sub CommandButton1_Click()
  ActiveWorkbook.Save
End Sub

Same for Close

Private Sub CommandButton2_Click()
  ActiveWorkbook.Close
End Sub

Hi Darrell456,

welcome to the forum.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I urge you to change your thread title before you place any more posts here.

A better title may be "button to save and close the workbook"

regards