Looking for and "auto save" option. I already have the "auto recovery"
option set to every 1 min. I had created a spread sheet and then opened
another spread sheet and when I closed the 2nd sheet it asked if I wanted to
save the changes and of course I said no, because I didn't want the 2nd
sheet, but then the program closed my 1st sheet and I lost everything.

Money,

From a previous post by Dave Peterson:

If you're running xl2k or earlier, install the autosave addin via
windows|Start button|settings|control panel|Add or remove programs

If you're running xl2002+, then if you can find a copy of the autosave addin
from an earlier version, it should work ok.

But xl2002+ has something called autorecovery. It's not the same as
autosave,
but will allow you to recover files if excel/windows crashes.

As an alternative, you may want to consider using Jan Karel Pieterse's addin
called AutoSafe (note spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a
user
selectable folder. And when it's done, it either deletes these backups (or
puts
them in the recycle bin). And the user can always restore the backups from
the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

Jan Karel's version will know if there was a crash and prompt you to open
the
last version it saved.


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Money Minded" <Money wrote in message
...
Looking for and "auto save" option. I already have the "auto recovery"
option set to every 1 min. I had created a spread sheet and then opened
another spread sheet and when I closed the 2nd sheet it asked if I wanted
to
save the changes and of course I said no, because I didn't want the 2nd
sheet, but then the program closed my 1st sheet and I lost everything.

Close the files by clicking on the internal X not the big X and you will only
close 1 file at a time. Or File Close.



"Money Minded" <Money wrote in message
...
: Looking for and "auto save" option. I already have the "auto recovery"
: option set to every 1 min. I had created a spread sheet and then opened
: another spread sheet and when I closed the 2nd sheet it asked if I wanted to
: save the changes and of course I said no, because I didn't want the 2nd
: sheet, but then the program closed my 1st sheet and I lost everything.