Button in Excel that will save the form?

[Jason]

How can i create a button to place on a sheet (i have multiple sheets) that
will automatically save it?

 

[Anne Troy]

Here's your code:

Sub SaveMe()
ActiveWorkbook.Save
End Sub

See where to place your code (very similar to this article For a Single
Document):
http://www.officearticles.com/word/what_to_do_with_macro_code_in_microsoft_word.htm
See how to run it from a button:
http://www.officearticles.com/misc/methods_to_run_a_macro_in_microsoft_office_applications.htm
************
Anne Troy
www.OfficeArticles.com