ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Button in Excel that will save the form? (https://www.excelbanter.com/excel-worksheet-functions/52583-button-excel-will-save-form.html)

Jason

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

Anne Troy

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?





All times are GMT +1. The time now is 03:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com