button for saving all workbooks

  • Thread starter Thread starter USH
  • Start date Start date
U

USH

hello !
anybody anybody knows that excel
has a "SAVE" button with a Floppy icon,
int the File Menu..

when you press this button you save the current workbook..

What if i have to save all open workbooks ???

tx !!
paolo
 
Don't know what autosave has to do with it but add this macro to your
Personal.xls

NOTE: will save all open workbooks without asking "do you want to save?"

Sub saveall()
Dim wb As Workbook
Application.DisplayAlerts = False
For Each wb In Application.Workbooks
wb.Save
Next
Application.DisplayAlerts = True
End Sub


Gord Dibben MS Excel MVP
 
tx all !
one more idea..
is it possible to set that sub as function of excel instead than insed a
workbook ?
 
Back
Top