Automatic Workbook Saving

[Giles-UK]

I posted this earlier today but it hasn't appeared as yet so I'll try again..

Can someone help me in setting up some simple code that does the following:- After 20 minutes (or so) after I last saved a file i want excel to throw up a dialogue box that says "Do you want to Save this Workbook?" YES/NO. If i hit yes it simply does a save as...and doesn't adk for another twenty mins.

I know that there is an autosave feature on excel but this doesn't ask if you want to so you could overwrite something you don't want to.

I have just started learning about VBA but I don't reckon it will be too hard to do!!!

Thanks in advance
Giles in the UK

 

[Paul B]

Auto save has a prompt before save, In excel '97 anyway

 

[Steve Hartman]

Excel 2000 does too.