AutoSave with Excel 2000 - prompting

[Guest]

In Excel 2000. The user wants to have autosave enabled. What can be done so that Autosave still works, but he is not prompted to save changes

Thanks

 

[bdcrisp]

open the VB editor, view object browser, select 'workbook' and then
before close

in this sub, place the following code:

ThisWorkbook.Save
ThisWorkbook.Saved = True





is that what you wanted? or were you looking for this to apply to the
application as a whole?

 

[Guest]

Does this apply to all Excel spreadsheets this person may open? He's not doing any coding. He has several Excel files that he uses, he wants Autosave, similar to how it works in Word, to save behind the scenes while he's working.

Sorry, my subject line is somewhat misleading.

 

[Stephen Bullen]

Hi Rob,

In Excel 2000. The user wants to have autosave enabled. What can be done so that Autosave still works, but he is not prompted to save changes?

Instead of using the AutoSave addin, you might like to try Jan Karel Pieterse's AutoSafe utility, available from the MVP page of my site.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Guest]

OK. Will this run in Excel 2000 (he may be getting a new laptop in Jan. which would have XP on it, but there's 23 days left of possible complaining)

Thanks

 

[Stephen Bullen]

Hi Rob,

OK. Will this run in Excel 2000 (he may be getting a new laptop in Jan. which would have XP on it, but there's 23 days left of possible complaining).

Yes

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk

 

[Mike A]

The autosave add-in can do exactly what you want, and it will apply to
all files open on that installation of Excel.

Go to Tools>Add-ins and check autosave; Click OK.

Now go to Tools>Autosave, set the delay time and uncheck Prompt before
saving. You can also set it to autosave the active workbook only or
all open workbooks. Click OK.





Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers