Reminder message in excel

[Kunehoman]

Hi, I'd like to get help on:

having a pop up reminder in excel "saying "pls save file now" also, I want it to pop-up every hour so that users in a shared workbook will be reminded to save the file.... much better that once they click the pop-up the file would automatically save.

is there such? Thanks in advance for the help.

 

[Joe4]

Welcome to the Board!

I think this is very close to what you want:
http://www.mrexcel.com/forum/showthread.php?t=510648

The code for saving the file is simply:
ActiveWorkbook.Save
(note that you can get a lot of VBA code simply by using the Macro Recorder and record yourself doing the steps manually).

 

[Kunehoman]

Thanks Joe, Im kinda starting from scratch though..I need a quick fix. thanks for the help.

 

[Joe4]

Thanks Joe, Im kinda starting from scratch though..I need a quick fix.

How quick in quick? (I responded a week ago!!!)

What you want to do is going to require VBA.
Did you take a look at the link I provided?