MsgBox Every X Amount of Minutes

[thefastlane]

Hey I was wondering if it was possible to have a MsgBox pop-up every X amount of minutes. Thanks!

 

[wigi]

And euhm... What's the purpose of that? Too much time on your hands and you want to close the MsgBox'es yourself?

Seriously, what is the business need?

 

[thefastlane]

And euhm... What's the purpose of that? Too much time on your hands and you want to close the MsgBox'es yourself?

Seriously, what is the business need?

Haha No, we have multiple computers in our office as well as users who work on a lot of the same spreadsheets. Also, excel will sometimes crash on us, leaving several workers with a lot of unsaved changes gone. I was hoping to simply have a MsgBox that popped up every 20 min or so to remind the user to SAVE his work. In the future we might link it to something, but right now I want to hammer it in that they need to save their work.

 

[wigi]

Excel has built-in functionality to save each x minutes... Did you know that?
Caveat: I don't know if that works when users share the same workbook, which (sharing workbooks), honestly, is a no-go in Excel. It's too risky most of the time.

 

[thefastlane]

I did, but sometimes we don't want it to save automatically. I've worked on a template for a worksheet that we use repeatedly for different jobs, and screwed something up in the sheet... At that point I wouldn't want the auto-save feature on. There have also been times when someone messed up a perfectly good template or sheet while entering in data, so we wouldn't want it there either. Also, we have a dropbox(cloud storage)that we save our excel sheets to, so everyone can access them(just not at the same time).

 

[wigi]

Well, you could use Application.OnTime:
Application.OnTime Method (Excel)

And many other topics here at MrExcel and elsewhere.
As I'm not a fan of these kind of methods, nor did I use it a lot in the past,
I suggest that you look for example code in other topics, and change to suit your purposes.
Again caveat, VBA and these kind of macro's might not work when sharing workbooks.

 

[wesimmo]

I did, but sometimes we don't want it to save automatically. I've worked on a template for a worksheet that we use repeatedly for different jobs, and screwed something up in the sheet... At that point I wouldn't want the auto-save feature on. There have also been times when someone messed up a perfectly good template or sheet while entering in data, so we wouldn't want it there either. Also, we have a dropbox(cloud storage)that we save our excel sheets to, so everyone can access them(just not at the same time).

Surely rather than spend time creating processing overhead and an ugly work around then just applying good practises would be beneficial?

Don't work on your live template, take a copy and work on that, and then when you've finished publish it somewhere for the users and keep a clean/safe copy elsewhere?