Auto Save a worksheet

[Russ Ragsdell]

I need to set up my system to automatically save a sheet I am working on
every 10 or so minutes. Recently spent an entire day on a sheet that was
extremely large only to close the file and forgot to properly save it. Any
help will be appreciated

Russ Ragsdell

 

[Frank Kabel]

Hi
a repost from Dave Peterson:
------
Short descriptions:

Autosave (an addin in xl versions before xl2002), the
workbook gets
saved at
user selectable intervals (just like a manual save). (If
you're
running
xl2002+, then if you can find a copy of autosave, it'll
work with that
version,
too.)

xl2002+ has a feature called autorecovery. It's used to
catch
catestrophic
events (excel/windows crashing). But it won't help if you
never save
or you
close excel normally.

But Jan Karel Pieterse has an addin that's the best of
both worlds:
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.

=====
You may want to get a copy of Jan Karel's addin. It might
save a few
tears in
the future.

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