button for saving all workbooks

[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

 

[JLGWhiz]

same button.

 

[USH]

maybe its a lot of open workbooks !!
and for some special reason i cant use autosave..

 

[JLGWhiz]

Maybe this will help:

http://www.dummies.com/how-to/content/how-to-save-files-in-windows-xp.html

 

[Gord Dibben]

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

 

[USH]

tx all !
one more idea..
is it possible to set that sub as function of excel instead than insed a
workbook ?

 

[Gord Dibben]

None that I know of.


Gord

tx all !
one more idea..
is it possible to set that sub as function of excel instead than insed a
workbook ?