G Guest Oct 27, 2005 #1 How can i create a button to place on a sheet (i have multiple sheets) that will automatically save it?
How can i create a button to place on a sheet (i have multiple sheets) that will automatically save it?
A Anne Troy Oct 27, 2005 #2 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
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
