Bandi

Try the advice below from Dave Peterson............

Dave Peterson Jul 21 2004, 6:49 pm

Newsgroups: microsoft.public.excel.misc
From: Dave Peterson - Find messages by this author
Date: Wed, 21 Jul 2004 20:49:59 -0500
Local: Wed, Jul 21 2004 6:49 pm
Subject: Auto Save Window

Maybe...

http://support.microsoft.com/default...b;en-us;231117
XL2000: AutoSave Settings Are Not Retained Between
Sessions of Excel 2000

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.)



Gord


On Sat, 22 Jan 2005 12:33:01 -0800, "Bandi"
wrote:



"Bandi" wrote:

How do I change autosave default settings. ie save all active sheets?

The setting is current work sheet only. Using the described method ,
requires changing every time I open Excel. How do I change the default
setting permanetly?