button for saving all workbooks
 

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

button for saving all workbooks
 

same button.


"USH" wrote in message
...
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

button for saving all workbooks
 

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




"JLGWhiz" wrote:

same button.


"USH" wrote in message
...
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


.

button for saving all workbooks
 

Maybe this will help:

http://www.dummies.com/how-to/conten...indows-xp.html



"USH" wrote in message
...
maybe its a lot of open workbooks !!
and for some special reason i cant use autosave..




"JLGWhiz" wrote:

same button.


"USH" wrote in message
...
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


.

button for saving all workbooks
 

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

On Tue, 18 May 2010 05:49:01 -0700, USH
wrote:

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




"JLGWhiz" wrote:

same button.


"USH" wrote in message
...
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


.

button for saving all workbooks
 

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


"JLGWhiz" wrote:

Maybe this will help:

http://www.dummies.com/how-to/conten...indows-xp.html



"USH" wrote in message
...
maybe its a lot of open workbooks !!
and for some special reason i cant use autosave..




"JLGWhiz" wrote:

same button.


"USH" wrote in message
...
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


.



.

button for saving all workbooks
 

None that I know of.


Gord

On Wed, 19 May 2010 09:31:01 -0700, USH
wrote:

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


"JLGWhiz" wrote:

Maybe this will help:

http://www.dummies.com/how-to/conten...indows-xp.html



"USH" wrote in message
...
maybe its a lot of open workbooks !!
and for some special reason i cant use autosave..




"JLGWhiz" wrote:

same button.


"USH" wrote in message
...
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


.



.