View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default Button in Excel that will save the form?

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/w...osoft_word.htm
See how to run it from a button:
http://www.officearticles.com/misc/m...ica tions.htm
************
Anne Troy
www.OfficeArticles.com


"Jason" wrote in message
...
How can i create a button to place on a sheet (i have multiple sheets)
that
will automatically save it?