Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jason
 
Posts: n/a
Default 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?
  #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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
save as isnt there neither is the save button pressable fernandzefruitcake Excel Discussion (Misc queries) 3 September 28th 05 04:15 PM
Excel Form link to e-mail Masud New Users to Excel 1 May 27th 05 04:48 PM
Save? prompt when closing Excel MC Excel Discussion (Misc queries) 4 March 12th 05 10:55 PM
View of Excel form is different on different computers. SJuker Excel Discussion (Misc queries) 1 March 9th 05 01:47 PM
Excel crashing on save as Roundy Excel Discussion (Misc queries) 1 December 10th 04 10:45 PM


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"