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
Wed Mar 06, 2002 1:16 pm
Paul B Board Master
Joined: 16 Feb 2002
Location: Nicholson, Georgia. USA
Auto save has a prompt before save, In excel '97 anyway
Wed Mar 06, 2002 1:24 pm
Steve Hartman Board Master
Joined: 18 Feb 2002
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
All contents Copyright 1998-2004 by MrExcel.com
If you believe information posted here is from your copyrighted source, notify us per the
Excel is a registered trademark of the Microsoft Corporation. MrExcel is a registered trademark of Tickling Keys, Inc.