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

same button.


"USH" <(E-Mail Removed)> wrote in message
news:4AB6F206-E52F-4B41-8516-(E-Mail Removed)...
> 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

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




"JLGWhiz" wrote:

> same button.
>
>
> "USH" <(E-Mail Removed)> wrote in message
> news:4AB6F206-E52F-4B41-8516-(E-Mail Removed)...
> > 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
>
>
> .
>

Maybe this will help:

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



"USH" <(E-Mail Removed)> wrote in message
news:9FC761E0-C4EE-45D6-AF4C-(E-Mail Removed)...
> maybe its a lot of open workbooks !!
> and for some special reason i cant use autosave..
>
>
>
>
> "JLGWhiz" wrote:
>
>> same button.
>>
>>
>> "USH" <(E-Mail Removed)> wrote in message
>> news:4AB6F206-E52F-4B41-8516-(E-Mail Removed)...
>> > 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

On Tue, 18 May 2010 05:49:01 -0700, USH <(E-Mail Removed)>
wrote:

>maybe its a lot of open workbooks !!
>and for some special reason i cant use autosave..
>
>
>
>
>"JLGWhiz" wrote:
>
>> same button.
>>
>>
>> "USH" <(E-Mail Removed)> wrote in message
>> news:4AB6F206-E52F-4B41-8516-(E-Mail Removed)...
>> > 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
>>
>>
>> .
>>

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" <(E-Mail Removed)> wrote in message
> news:9FC761E0-C4EE-45D6-AF4C-(E-Mail Removed)...
> > maybe its a lot of open workbooks !!
> > and for some special reason i cant use autosave..
> >
> >
> >
> >
> > "JLGWhiz" wrote:
> >
> >> same button.
> >>
> >>
> >> "USH" <(E-Mail Removed)> wrote in message
> >> news:4AB6F206-E52F-4B41-8516-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >> .
> >>
>
>
> .
>

None that I know of.


Gord

On Wed, 19 May 2010 09:31:01 -0700, USH <(E-Mail Removed)>
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" <(E-Mail Removed)> wrote in message
>> news:9FC761E0-C4EE-45D6-AF4C-(E-Mail Removed)...
>> > maybe its a lot of open workbooks !!
>> > and for some special reason i cant use autosave..
>> >
>> >
>> >
>> >
>> > "JLGWhiz" wrote:
>> >
>> >> same button.
>> >>
>> >>
>> >> "USH" <(E-Mail Removed)> wrote in message
>> >> news:4AB6F206-E52F-4B41-8516-(E-Mail Removed)...
>> >> > 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
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>