Hello - I would like to have a macro run on every new file that displays a message after the file has been open for 5 minutes, reminding the user to save. Can anyone help? Thank you in advance!s
Hello - I would like to have a macro run on every new file that displays a message after the file has been open for 5 minutes, reminding the user to save. Can anyone help? Thank you in advance!s
Try this code..
Copy and paste following code in the "ThisWorkbook" Module..
It will be automatically activated when workbook gets open..
Don't forget to click *![]()
Please Login or Register to view this content.
Last edited by Vikas_Gautam; 08-06-2014 at 01:02 PM.
Why not just set excel to auto-save after 5 minutes?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Becuase the issue I have is not with the computer or program crashing -- it is with users who forget to save, hit close and still forget to save![]()
When I run it I receive "Compile Error" Sun or Function not defined
I got your problem...
You have copied the code at wrong place..
click this link to see the whole demonstration...
http://excel-buzz.blogspot.in/2014/0...ile-after.html
check the attachment..
Don't forget to click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks