How do I stop Excel goes to the first worksheet when autosave pro.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Saphire - 11 Sep 2004 08:39 GMT

My Excel workbook just jumps to the first worksheet of the workbook instead
of staying on the worksheet I am working on when autosave prompts. How do I
change that?

Reply to this Message

Dave Peterson - 11 Sep 2004 11:27 GMT

I don't think you can.

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

> My Excel workbook just jumps to the first worksheet of the workbook instead
> of staying on the worksheet I am working on when autosave prompts. How do I
> change that?

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message